Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Display ratio in row

Hi,   I want to display ratio in row. It likes the image following. But I only realized ratio in column. I created a measure following to calaculte ratio. Ratio % = DIVIDE(CALCULATE('Query...
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Ashish_Mathur 

     

    I realized my expected result following:

     

     

    Actual N (New) =
    IF(
        FIRSTNONBLANK('Table ldesc2'[ldesc2], 1) = "Ratio %" && NOT( HASONEFILTER(STAR_Detailed_group_PL[ldesc2]) ),
        FORMAT(
        CALCULATE(
            'Query1'[Actual N],
            FILTER(ALL('STAR_Agregated_group_PL'),'STAR_Agregated_group_PL'[ldesc2]="Net margin")
        )
        /
        CALCULATE(
            'Query1'[Actual N],
            FILTER(ALL('STAR_Detailed_group_PL'),'STAR_Detailed_group_PL'[ldesc2]="NET ACTIVITY TURNOVER")
        ), "00%"),
        [Actual N]
    )
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

I do not understand your requirement.  What is your expected result?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Ashish_Mathur 

 

I realized my expected result following:

 

 

Actual N (New) =
IF(
    FIRSTNONBLANK('Table ldesc2'[ldesc2], 1) = "Ratio %" && NOT( HASONEFILTER(STAR_Detailed_group_PL[ldesc2]) ),
    FORMAT(
    CALCULATE(
        'Query1'[Actual N],
        FILTER(ALL('STAR_Agregated_group_PL'),'STAR_Agregated_group_PL'[ldesc2]="Net margin")
    )
    /
    CALCULATE(
        'Query1'[Actual N],
        FILTER(ALL('STAR_Detailed_group_PL'),'STAR_Detailed_group_PL'[ldesc2]="NET ACTIVITY TURNOVER")
    ), "00%"),
    [Actual N]
)