Forum Discussion
Count rows for some conditions
Can I get a quick Dax here please ?
Bear in mind that in actual problem, ACV and Sales Amount are not calculated mesaures.
I am new to Dax
Hi Anonymous ,
How about this:
Here the DAX for the measure :
CountMeasure = COUNTROWS ( FILTER ('Table', 'Table'[Sales Amount] < 190 && 'Table'[ACV] <= 0.9 ) )Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
1 Reply
- tackytechtom
Most Valuable Professional
Hi Anonymous ,
How about this:
Here the DAX for the measure :
CountMeasure = COUNTROWS ( FILTER ('Table', 'Table'[Sales Amount] < 190 && 'Table'[ACV] <= 0.9 ) )Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/