Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys,
I am facing issue to get denominator to calculate percentage, i don't have any issue with Numerator since it is just a distinct count of projects but i am facing issue with denominator. I need to sum the count for individual category.
Please find the attached pbix with sample data
https://drive.google.com/file/d/1grYgcTwNLzWdZdB4gLPwbpH23_NwcQb6/view?usp=sharing
Solved! Go to Solution.
Hi @HemanthV ,
I'd suggest you create a new table and then create a measure separately:
Summarized = SUMMARIZE('Table','Table'[Axis],'Table'[Value],"Count", DISTINCTCOUNT('Table'[Project Name]))
Measure = CALCULATE(SUM(Summarized[Count]),FILTER('Summarized',[Axis]=MAX('Table'[Axis])))
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @HemanthV ,
I'd suggest you create a new table and then create a measure separately:
Summarized = SUMMARIZE('Table','Table'[Axis],'Table'[Value],"Count", DISTINCTCOUNT('Table'[Project Name]))
Measure = CALCULATE(SUM(Summarized[Count]),FILTER('Summarized',[Axis]=MAX('Table'[Axis])))
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@HemanthV , change this and try
var denominator = CALCULATE( SUMX(filter(virtable,[Axis] =max([Axis])),[Count]))
Hi @amitchandak ,
Thanks for your reply. I have tried it, but it did not worked.
I have provided sample pbix, can you please try on that file?
Please find the attached pbix with sample data
https://drive.google.com/file/d/1grYgcTwNLzWdZdB4gLPwbpH23_NwcQb6/view?usp=sharing
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |