Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Good afternoon
I'm stuck to make this formula. What I need is a different count of dates, but one that takes into account both the month and the id.
That is, in month 7, the 100 employee has been there for 3 days.
Would there be any way to put this double filter?.
It will make you catch the month filter:
But for the employee filter, you have to depend on each employee, not do a =100 (for example)
In other words, I don't want to:
Solved! Go to Solution.
@Anonymous,
Try this measure:
RESULTADO CONTAR DISTINTO =
CALCULATE (
DISTINCTCOUNT ( 'Production Data: Capacity Hours (Antonio)'[DAY] ),
ALLEXCEPT (
'Production Data: Capacity Hours (Antonio)',
'Production Data: Capacity Hours (Antonio)'[ID],
'Production Data: Capacity Hours (Antonio)'[MO]
)
)
Proud to be a Super User!
@Anonymous,
Try this measure:
RESULTADO CONTAR DISTINTO =
CALCULATE (
DISTINCTCOUNT ( 'Production Data: Capacity Hours (Antonio)'[DAY] ),
ALLEXCEPT (
'Production Data: Capacity Hours (Antonio)',
'Production Data: Capacity Hours (Antonio)'[ID],
'Production Data: Capacity Hours (Antonio)'[MO]
)
)
Proud to be a Super User!
That's great!!!
It works perfect. Thanks a lot!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
107 | |
106 | |
91 | |
67 |
User | Count |
---|---|
162 | |
133 | |
132 | |
93 | |
91 |