Forum Discussion
Helper IHelp with DAX conditional count of orders
Greg_Deckler Thanks Greg, I will be sure to include in the future. I actually found an answer:
Qualified Order Count =
Var units = Order Units
Return
Calculate(
DistinctCount('Table 1',
filter('Table 1', units >=5))
Passing the measure as a variable seems to do the trick, althought I am not 100% certain as to why.
Community ChampionSample data would be tremendously helpful to replicate and test. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Helper IGreg_Deckler Thanks Greg, I will be sure to include in the future. I actually found an answer:
Qualified Order Count =
Var units = Order Units
Return
Calculate(
DistinctCount('Table 1',
filter('Table 1', units >=5))
Passing the measure as a variable seems to do the trick, althought I am not 100% certain as to why.
v-chuncz-msftCommunity Support
By the way, you may help accept solution. Your contribution is highly appreciated.