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'm having a hard time how to figure this out by counting the column Value by Region. As you can see below, total counts on each Value is the same.
Your help is greatly appreciated.
Table
You can try this calculated column:
Column =
CALCULATE(DISTINCTCOUNT('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Region]=EARLIER('Table'[Region])))
Is your data formed through Unpivot Columns? You don’t need this step or you can display the results you need.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I think this is what you are trying to do...
Create a Measure for each Country, that will be the columns you need: (Examples - repeat for every country)
Here's the raw data and final result...
Proud to give back to the community!
Thank You!
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |