Forum Discussion

wdrain's avatar
wdrain
Helper I
2 years ago

Row Counts based on field parameters selections

Could someone help me with a dax calculation that counts uses the countrows functions based on field parameter selection menu. based on the screenshot below it would need to do a row count based u...
Need Help
amitchandak's avatar
amitchandak
Super User
2 years ago

wdrain , Assume your measure is M1 used in visual  , and your axis /row/group by is column1

 

compliant =

_var count = countrows(values(Table[Software]))

return

sumx( Values(Table[Column1]) , if( calculate(SUmx(Values([Software]),[M1])) =_var, 1, blank() ) )

 

 

Non compliant =

_var count = countrows(values(Table[Software]))

return

sumx( Values(Table[Column1]) , if( calculate(SUmx(Values([Software]),[M1])) =0, 1, blank() ) )

wdrain's avatar
wdrain
Helper I
2 years ago

Hi Amitchandak

Thanks for the dax formula, but I don't think it applies to my datamodel or I am not sure on how to adjust to make it apply.

I don't have the permission to share my pbix file, but I can share screenshot of the sample data and the datamodel.

As mentioned earlier, I'm looking for a Compliant and Non Compliant count based the slicer selection 
Compliant count should be when all software selection equal 1