SSAS Tabular calculated measures missing from Power View fields list
I have defined a calculated measure named "Gross Margin" for my "FactInvoiceLineItem" table. I can see this measure in the Measures dimension (along with several others):
These measures work fine in a PivotTable, but they are absent from the field list in Power View:
I've seen similar issues with PowerPivot and e.g. date columns but that issue shouldn't apply here since the result of the calculation is numeric. We've tried wrapping the calculation in a CALCULATE() anyway, but it didn't help.
There are examples of using measures with Power View from a PowerPivot model. Am I missing some setting in my model, or is this a quirk with Power View and SSAS Tabular?
As mmarie suggests, it's not a limitation of Power View and Tabular - except that Power View only supports numeric measures.
We had included in our calculated measure some custom formatting using FORMAT() to apply parenthesis to negative numbers, which rendered our nice numeric calculation into text. Thus, Power View wouldn't display our measures because they were no longer numeric!
Stripping the FORMAT() out returned the calculation to a numeric type, and made it available in Power View.
- Searching for strings with double quotes in SQL Server
- Check if table exists in SQL Server
- The database 'xxx' cannot be opened because it is version 904
- Insert Update trigger how to determine if insert or update
- SQL query to determine whether it is day or evening
- Invalid value specified for connection string attribute
- Reset identity seed after deleting records in SQL Server
- Call a stored procedure with parameter in c#
- Join 3 tables without table 2 and 3 overlapping
- How to run SQL Server Agent Powershell script with output and exit code
- Refer to original value within CASE statement
- alternative to xp_cmdshell bcp?
- Querying data from SQL Server table with Powershell
- How to export data as CSV format from SQL Server using sqlcmd?
- ExecuteScalar() not returning full contents of cell
- SQL Query to select certain number of records with WHERE clause
- How to select 10 rows for a each column value in the 'IN' statement (T-SQL)
- How to execute a .sql file using PowerShell
- "The certificate chain was issued by an authority that is not trusted" when connecting DB in VM Role from Azure website
- Invoke-Sqlcmd doesn't allow TrustServerCertificate
- Can you insert into a replicated SQL Server DB?
- How to set up a Windows Docker Container with SQL Server?
- Remove trailing spaces from fixed length in output file generated by sqlcmd
- How to suppress hyphens in SQLCMD
- Error when adding replication logreader agent with login
- Differences Between Drivers for ODBC Drivers
- Calculate value based on sum of previous calculated values
- Get all the table names that are available in all the <s>schemas</s> databases in SQL Server
- Detect character encoding of file in SQL Server
- What performs better: Bunch of UNION queries vs separate queries?