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 guys,
I have following table
month |
1 |
2 |
3 |
4 |
5 |
6 |
And I need to create measure that will return count of month and not be affected by selection/filter of months, I create this DAX formula, but for unknown reason it is not working, any reason why? and what should be correct syntax ?
measure= CALCULATE(DISTINCTCOUNT(Table[month]),ALL(Table,Table[month])))
Solved! Go to Solution.
You set a filter on Date column so use one of these:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
HI @Petr__
Try this:
measure= CALCULATE(DISTINCTCOUNT(Table[month]),ALL(Table[month]))
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hell @Vahid this is what I mentioned in 2nd post (I have typo here with ")") but it doesn t work
Can you share you PBIX file?
or try this if you set a filter on month and you want to ignore that:
measure =
CALCULATE ( DISTINCTCOUNT ( Table[Month] ), REMOVEFILTERS ( Table[Month] ) )
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
@VahidDM got it...I was filtering on the different column than filter was set up in the report
You set a filter on Date column so use one of these:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Also find it, few minutes after you 😄 kudos sent 🙂
I also tried
measure
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |