Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello - I'm fairly new to using PBI and DAX. I'm hoping someone could assit with a pretty straight forward calculation I need. I have a column of ID's. I need to be able to count a specific ID based on date being >= 2024-05-01.
Solved! Go to Solution.
@KellyLo , You can get the desired result using a measure
CountSpecificID =
CALCULATE(
COUNTROWS(YourTable),
FILTER(
YourTable,
YourTable[ID] = "YourSpecificID" && YourTable[Date] >= DATE(2024, 5, 1)
)
)
Please replace table and column name with what you have in your report
Proud to be a Super User! | |
THANK YOU!
@KellyLo , You can get the desired result using a measure
CountSpecificID =
CALCULATE(
COUNTROWS(YourTable),
FILTER(
YourTable,
YourTable[ID] = "YourSpecificID" && YourTable[Date] >= DATE(2024, 5, 1)
)
)
Please replace table and column name with what you have in your report
Proud to be a Super User! | |
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
58 | |
29 | |
21 | |
16 |