Row Counts based on field parameters selections

Question

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 using a dynamic filter based on the menu selection and count the rows that all equal 1. the dax caculation would need to equal the values in the compliant and non-compliant boxes

amitchandak · Answer

wdrain , Assume your measure is M1 used in visual&nbsp; , and your axis /row/group by is column1 
&nbsp;
compliant =
_var count = countrows(values(Table[Software]))
return
sumx( Values(Table[Column1]) , if( calculate(SUmx(Values([Software]),[M1])) =_var, 1, blank() ) )
&nbsp;
&nbsp;
Non compliant =
_var count = countrows(values(Table[Software]))
return
sumx( Values(Table[Column1]) , if( calculate(SUmx(Values([Software]),[M1])) =0, 1, blank() ) )

ashish_mathur · Answer

Hi,
Share the download link of the PBI file.

wdrain · Answer

Hi AmitchandakThanks 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&nbsp;Compliant count should be when all software selection equal 1&nbsp;