Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I have a problem with the following measure. It should return the number of distinct elements in the related field, excluding the BLANK () values. The measure works correctly in all fields except the one affected by the selected filter (it should return the value 1).
How can I fix this?
Thanks for your help
Solved! Go to Solution.
HI @FinozAndrea ,
Try adding a FILTER statement to your DAX along with ALL SELECTED, so that it considers all the filters coming from outside.
As you haven't pasted your DAX, I am trying to write a sample:
N Comp liv 4 = Calculate(DISTINCTCOUNT(tablename[column1]), FILTER(ALLSELECTED(tablename), tablename[column1] <> BLANK()))
Try using your tablename and column name in above dax.
Thanks,
Pragati
HI @FinozAndrea ,
Try adding a FILTER statement to your DAX along with ALL SELECTED, so that it considers all the filters coming from outside.
As you haven't pasted your DAX, I am trying to write a sample:
N Comp liv 4 = Calculate(DISTINCTCOUNT(tablename[column1]), FILTER(ALLSELECTED(tablename), tablename[column1] <> BLANK()))
Try using your tablename and column name in above dax.
Thanks,
Pragati
It works,
thankyou very much!
User | Count |
---|---|
77 | |
74 | |
63 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |