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,
I have created a measure that counts the number of rows based on Date & Name column.
However the measure is not getting changed according to the slicer selection. Please help me find the issue.
Here is my code:
CountVal = CALCULATE ( COUNTROWS (Sample), ALLEXCEPT (Sample,Sample[Date], Sample[Name] ) )
Sample table:
I am using date dimension for the date slicer.
Thanks!
Solved! Go to Solution.
Also:
CountVal1 = CALCULATE ( COUNTROWS ('Sample'), ALLEXCEPT ('Sample','Calendar'[Date], 'Sample'[Name] ) )
Also:
CountVal1 = CALCULATE ( COUNTROWS ('Sample'), ALLEXCEPT ('Sample','Calendar'[Date], 'Sample'[Name] ) )
Dumb question, is your Date dimension related to your fact table?
Yes. Other measures created on this fact table are in sync with the slicers.
Right, see my second response, you need to ALLEXCEPT your date dimension, not your fact table for the date at least.
Tried but still facing the same issue.
Hmm, mine seems to work like a champ. See attached.
Thank you so much! It works now! I was using DateId column instead of Date column in my measure. But my slicer was using date column.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |