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.
I have a simple table that looks like below. I want to get a sum/total of Unique Claim numbers by month (users have a date slicer to choose).
I tried just Distinct Count(# Unique ClaimsProcessed = DISTINCTCOUNT('Claims Pmts Processed Upload'[Claim #]), but it doesn't change when I choose a specific month from the slicer . I aslo tried this
Solved! Go to Solution.
Hi @atowriss74 ,
Based on your description, do you create formulas that retain an external filtering context (such as a date field).
Refer to the following formulas (one contains a date filter, one does not)
M_ = CALCULATE(DISTINCTCOUNT('Table'[Category]),ALL('Table'))
M_slicerDate =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Category] ),
ALLEXCEPT ( 'Table', 'Table'[Date] )
)
If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @atowriss74 ,
Based on your description, do you create formulas that retain an external filtering context (such as a date field).
Refer to the following formulas (one contains a date filter, one does not)
M_ = CALCULATE(DISTINCTCOUNT('Table'[Category]),ALL('Table'))
M_slicerDate =
CALCULATE (
DISTINCTCOUNT ( 'Table'[Category] ),
ALLEXCEPT ( 'Table', 'Table'[Date] )
)
If the problem is still not resolved, please provide detailed error information and test data. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @atowriss74 ,
in the link below you find the pbi file. In my file the slicer works good.
https://1drv.ms/u/s!Aj45jbu0mDVJiG2gubFw9YrtOIpP?e=oxApUl
Please hit the thumb and accept my answer as solution!!!
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 |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |