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,
This might be very simple calculation but I am having trouble producing this in the report.
I need help in displaying % value in a card visualization. The calculation should go like this -
ZeroEnrol/Count of Enrollment_count*100 = 1.30%
30/2304*100 = 1.30%
ZeroEnrol is a "Calculated Measure" and
Enrollment_count is a Measure field from the actual query.
What mdx should I use to retrieve this calculation?
The values and column names is shown below for reference.
Thanks for your insights!
Solved! Go to Solution.
Hi,
Try this measure
=[ZeroEnrol]/SUM(Enrollment_Count)
I am assuming that enrollment count is a numeric column in your dataset.
Hi,
Try this measure
=[ZeroEnrol]/SUM(Enrollment_Count)
I am assuming that enrollment count is a numeric column in your dataset.
It is numeric and instead of SUM I placed count and worked perfectly. Thanks @Ashish_Mathur. Much appreciate your insight!
You are welcome.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |