Suppose you have the following data, and you are creating a relationship with the Calendar table.
The matrix visual uses DAX ("measure") to count the unique number of each Category.
measure = DISTINCTCOUNT(Table1[category])
Currently, we are showing the overall number of unique values (A, B, C = 3), but we would originally like to show the total number of unique values(3+2+2+1=8) for each month.
If you have any good ideas on how to make this happen, could you please let me know?
Go to Solution.
@Lopez0090 Please try this measure
⭕ Subscribe and learn Power BI from these videos ⚪ Website ⚪ LinkedIn ⚪ PBI User Group
View solution in original post
Genius! Thank you so much.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.