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 Everyone,
I have a requirenment to display a percentage average value in the bar chart
i.e. Sum(Calculated measure) / Total (Calculated measure).
Formula for calculating Calculated Meaure is calculate ( distinctcount(organization) , filter( Table, ID<>5959)).
Please help me to achieve this.
I have visited the following post https://community.powerbi.com/t5/Desktop/how-to-count-distinct-values-in-a-column/m-p/93218#M39342
Thanks
Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.
Regards,
Jimmy Tao
So [organization] is a calculate column or measure? If it is a measure, measure can not be used in an aggregation function, you should use a calculate column instead of measure.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |