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]
    )
v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

Your issue is referred to the red part why it have data been calculated ? it should be blank as other sublevel rows, right?

 

Best Regards,

Amy

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, v-xicai and Ashish_Mathur 

 

Thank you for your reply. Yes, it's one of my questions. Why were the sublevels of NET ACTIVITY TURNOVER calculated?  I created a formula following to calculate Net margin / NET ACTIVITY TURNOVER

Ratio % = DIVIDE(CALCULATE('Query1'[Actual N], FILTER('STAR_Agregated_group_PL','STAR_Agregated_group_PL'[ldesc2]="Net margin")),
CALCULATE('Query1'[Actual N],FILTER('STAR_Detailed_group_PL', 'STAR_Detailed_group_PL'[ldesc2]="NET ACTIVITY TURNOVER")))
 
I want to put ratio under the Net margin or Total, it likes this:
 

Could you help me?

I am looking forward to hearing from you soon.

 

Besta regards./