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, i have a table like this :
Id Date Count
1069 1/12/2018 1
1069 1/20/2018 0
...
1069 2/02/2018 1
TOTAL 2
I would like to count each ID by month (DISTINCTCOUNT(Id) => it's ok i have a relation to a date Table.
BUT
i would like to create a measure to sum all the Id by month to have 2 on TOTAL, and in my case, he counts 1
How to resolve ?
Thanks
Solved! Go to Solution.
Please try this MEASURE
Measure = IF ( HASONEFILTER ( Table1[Date].[Month] ), CALCULATE ( DISTINCTCOUNT ( Table1[Id] ) ), SUMX ( ALLSELECTED ( Table1[Date].[Month] ), CALCULATE ( DISTINCTCOUNT ( Table1[Id] ) ) ) )
Please try this MEASURE
Measure = IF ( HASONEFILTER ( Table1[Date].[Month] ), CALCULATE ( DISTINCTCOUNT ( Table1[Id] ) ), SUMX ( ALLSELECTED ( Table1[Date].[Month] ), CALCULATE ( DISTINCTCOUNT ( Table1[Id] ) ) ) )
Sample file attached as well
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 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |