Forum Discussion
counting values with conditions using DAX
I feel like this is a very simple questions, but can't seem to get it to work. I'm trying to do a countif in essence. I basically want to summarize the number of machines needed to make certain...
Hi,
So you want to get the table to ignore every filter context but product? Here is an example on how to do that:
Data:
Dax:Measure 13 = CALCULATE(COUNTROWS(NumberOfMachines),ALLEXCEPT(NumberOfMachines,NumberOfMachines[Product]))End result:I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
ValtteriN
Community Champion
Community ChampionHi,
So you want to get the table to ignore every filter context but product? Here is an example on how to do that:
Data:
Dax:
Measure 13 = CALCULATE(COUNTROWS(NumberOfMachines),ALLEXCEPT(NumberOfMachines,NumberOfMachines[Product]))
End result:
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
I think that is going to work. I will have to check once I get to writing the DAX formula. Thank you for the help.