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 everybody,
I have a dataset including columns of region, country and sales. What I want to create is a filter based on region and a chart/card which shows the number of sales and the number of countries according to region. The chart/card need to be dynamic and changed when I change the filter of region. Do you know any measures which can solve this?
Many thanks!
Solved! Go to Solution.
hi @kimlien3006 - You can achieve this by creating a measure for Sales and Count of rows - please see screen grabs of how you can implement the same.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
hi @kimlien3006 - You can achieve this by creating a measure for Sales and Count of rows - please see screen grabs of how you can implement the same.
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
Thanks a lot! It works well.
hi @kimlien3006 - Happy to help!
Proud to be a Super User!
Ill have a go
I set up a dataset
then Created two measures
Im guessing Im off the mark on this one because its quite a simple solution but I think it answers your question on the number of sales and the number of countries according to region
🙂 I realised you post header specified to not use DISTINCTCOUNT. Apologies. I went straight in for a DISTINCTCOUNT measure
Why wouldn't you just use countrows in the first instance and sum([sales]) in the second instance?
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |