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,
I'm having problem with these calculations... Basically, my goal is to get two numbers:
1: number of total distinct workers from start of selected date period
2: number of total distinct workers from end of selected date period
*And it has to be responsive to the group and date filtering.
Columns I have:
[Group]
[Works since]
[Name]
[Distinct count column] (idk if I need it?)
As I imagine it should work like this?:
Solved! Go to Solution.
@DomantasK Not sure I 100% understand but should be something like:
SUMX(ALLSELECTED('Table'),[Distinct Count Column])
@DomantasK Not sure I 100% understand but should be something like:
SUMX(ALLSELECTED('Table'),[Distinct Count Column])
And it really was just that simple... Thank you, works perfect! 🙂
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |