cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

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

6 REPLIES 6
Helper I

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?

Super User

Hi,

Regards,
Ashish Mathur
http://www.ashishmathur.com
Helper I

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.

Super User

Screenshots do not help.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Super User

@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() ) )

Helper I

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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.