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.
This is a simple idea, but I can't figure out how to do it.
I only need three columns in a table:
object_id (int key), event_month (date), event_condition (logical)
Even if condition is FALSE, there may be a date.
I just want to get the maximum count of conditioned objects based on date.
Monthly_Max = MAXX( KEEPFILTERS(VALUES([event_month])), COUNTX(FILTER('Table', [event_condition] = TRUE()),
[object_id])) )
But the second filter, doesn't respect the first filter.
And I have tried other ways with CALCULATE with no success.
I feel like this is gonna be easy, but I still need to get my head around it.
Thanks
Solved! Go to Solution.
Hi @Diego-mx,
You can create a measure below:
CountTrue = CALCULATE(COUNT(Table1[object_id]),FILTER(ALL('Table1'),'Table1'[event_condition]=TRUE()))
Best Regards,
Qiuyun Yu
Hi @Diego-mx,
You can create a measure below:
CountTrue = CALCULATE(COUNT(Table1[object_id]),FILTER(ALL('Table1'),'Table1'[event_condition]=TRUE()))
Best Regards,
Qiuyun Yu
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 |
---|---|
106 | |
96 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |