Forum Discussion
Dynamically format measure from SSAS Tabular to Power BI
Hi Lotta
Based on my research, it is not supported in SSAS live connection mode. Below are some similar posts for your reference.
https://community.powerbi.com/t5/Desktop/Data-type-of-calculated-measures-in-Import-Mode/td-p/143923
Regards,
Cherie
Hi Lotta
Did you import the data? If so, could you share the sample file for us to check? MAX Function can be replaced with FIRSTNONBLANK Function as your second measure. Maybe you need check if measure= FORMAT(DIVIDE(FinanceFacts[EBIT_]; FinanceFacts[Revenue_]; 0); “##0.0 %”) is blank value,because in my test, the IF condition seems correct.
Regards,
Cherie
Hi v-cherch-msft,
It's a live connection.
Neither the percentage measure or elinimation is empty as they are shown in Excel and in the SQL SSAS Tabular browser.
It seem to be specific to Power BI?
Kind Regards
Lotta
Hi Lotta
Based on my research, it is not supported in SSAS live connection mode. Below are some similar posts for your reference.
https://community.powerbi.com/t5/Desktop/Data-type-of-calculated-measures-in-Import-Mode/td-p/143923
Regards,
Cherie
Hi v-cherch-msft,
Thanks - that is what I was afraid of.
I posted as a desperate last chance that Power BI should have same abilities as Excel as a minimum.
Kind Regards
Lotta