Hi,
I want to display the ratio in row. It likes the image following.
But I only realized the ratio in column. I created a measure following to calculate the ratio, but the ratio was show in column.
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 don't understand why the sublevel of "NET ACTIVITY TURNOVER" calculate ratio too.
Do you have a good ideal?
I am looking forward to hearing from you soon.
Best regards.
------------------------------
Wei
------------------------------