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.
Hello
I am trying to create some visuals where my users will be able to compare the latest data to any point in time using a slicer.
I am trying to create a measure that filters to only count rows of my table that are equal to the MAX date in that table which I can do and looks like this:
Solved! Go to Solution.
Try adding and ALL() filter to your CALCULATE statement. CALCULATE is the only function that can modify the filter context created by things like slicers.
Test = CALCULATE(COUNT(Data[Emp Count]),ALL(Data),(filter(Dates,Dates[Date]=max(Data[Month]))))
I learn something every time I answer a question
I'm a personal Power BI trainer
Help when you know. Ask when you don't!
Try adding and ALL() filter to your CALCULATE statement. CALCULATE is the only function that can modify the filter context created by things like slicers.
Test = CALCULATE(COUNT(Data[Emp Count]),ALL(Data),(filter(Dates,Dates[Date]=max(Data[Month]))))
I learn something every time I answer a question
I'm a personal Power BI trainer
Help when you know. Ask when you don't!
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |