Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
101 | |
90 | |
79 | |
70 | |
70 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |