Row Counts based on field parameters selections

[wdrain]

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

[wdrain]

Ok This is what I came up with for the compliance count based on the selection, but know there gotta be a better way. Does anyone know how to code this more efficently?

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[wdrain]

Hi Ashish

I was'n able to share a download link of the pbi file, but I did post screenshots of the datamodel of the pbix file.

I hope that helps.

[Ashish_Mathur]

Screenshots do not help.

[amitchandak]

@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]

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