Forum Discussion

Lotta's avatar
Lotta
Frequent Visitor
7 years ago
Solved

Dynamically format measure from SSAS Tabular to Power BI

Hi,    I have tried various ways to format a measure dynamically from SSAS Tabular to Power BI Desktop. In Excel all versions of my tries works like a charm. But as soon as I connect to the cube ...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Lotta

 

Based on my test as below picture, it seems the second measure is correct. Just try again with below measure. If it is not your case, please share more details about your data sample so that we could help further on it. 

Try =
IF (
    MAX ( 'Statement Lines'[Line] ) = "Elimination",
    Finance[Elimination_],
    IF (
        MAX ( 'Statement Lines'[Line] ) = "CB1 %",
        FORMAT ( DIVIDE ( Finance[CB1_], Finance[Revenue_], 0 ), "##0.0 %" ),
        IF (
            MAX ( 'Statement Lines'[Line] ) = "EBIT %",
            FORMAT ( DIVIDE ( Finance[EBIT_], Finance[Revenue_], 0 ), "##0.0 %" ),
            [Report value]
        )
    )
)

 

Regards,

Cherie

 

Lotta's avatar
Lotta
Frequent Visitor
7 years ago

Hi v-cherch-msft, 

 

Thanks for the suggestion. 
I can't get to work, though, as the MAX function does not take a string as argument.

Statement_Lines[Line] are stings.

Below a part of the SSAS Tabular model. We are using SQL Server 2016, SP1.

The users select Stement_lines[Line] on row and the measure as value.
Child is also strings.

This is an atempt to show report rows and the different values on the rows for the matching Statement_Lines[Line].

 

Kind regards

Lotta