Reply
wdrain
Helper I
Helper I
Partially syndicated - Outbound

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

image.pngimage.png

6 REPLIES 6
wdrain
Helper I
Helper I

Syndicated - Outbound

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?

image.png

 

Ashish_Mathur
Super User
Super User

Syndicated - Outbound

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Syndicated - Outbound

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.

Syndicated - Outbound

Screenshots do not help.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

Syndicated - Outbound

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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Syndicated - Outbound

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 

image.pngimage.pngimage.pngimage.pngimage.pngimage.png

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric Community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)