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 All()
Considering I have the following column chart:
Where the category in the axis is Age Range, and the values on each column are actually a measure the counts the number of a certain group of people falling in those categories (it is actually a very simple measure).
I want a card that returns the category with the largest amount of people on it. Considering the chart above, the card would return "De 20 a 30". As simple as that.
Any thoughts?
Solved! Go to Solution.
Hi,
Try utilizing MAXX:
e.g.
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Hi,
Try utilizing MAXX:
e.g.
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
Dear @ValtteriN
The solution you provided works well, Thank you SO MUCH for your prompt response 😃
I chose to author the measure a bit different, with an ADDCOLUMNS statement surrounding the measure. (Marco Russo and Alberto Ferrari say this is a best practice in some cases. Please refer to this video https://www.sqlbi.com/articles/best-practices-using-summarize-and-addcolumns/).
Thank you so much once again! Going accept this as a solution and connect with you on Linkedin.
Regards!
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 |
---|---|
38 | |
26 | |
20 | |
15 | |
8 |
User | Count |
---|---|
69 | |
47 | |
46 | |
20 | |
15 |