Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
I don't understand why the sublevel of "NET ACTIVITY TURNOVER" calculate ratio too.
Could you help me?
I am looking forward to hearing from you soon.
Best regards.
Solved! Go to Solution.
I realized my expected result following:
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
Hi, @v-xicai and @Ashish_Mathur
I created a measure following to calculate Net margin/NET ACTIVITY TURNOVER.
But I got a ratio following:
But I don't know why NET ACTIVITY TURNOVER is calculated 100%. How to hide this 100%?
I am looking forward to hearing from you soon.
Best regards.
Hi @Anonymous ,
How about the DAX below?
Measure1= IF(MAX('STAR_Detailed_group_PL'[ldesc2])="NET ACTIVITY TURNOVER"&&,[Measure 3]<>BLANK(),BLANK(),[Measure 3])
Best Regards,
Amy
Hi @v-xicai ,
Thank you for your suggestion.
I created a new measure using another suggestion:
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
Could you help me?
I am looking forward to hearing from you soon.
Besta regards./
Hi,
I do not understand your requirement. What is your expected result?
I realized my expected result following:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
101 | |
72 | |
68 | |
45 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |