Reply
Syndicate_Admin
Administrator
Administrator
Syndicated - Inbound

DAX measure

Source Community: Power BI Spanish | Source Author Name: Maximiliano

Hello. I need help!!!

I'm having trouble creating a dax measure. I have a table with person ID / appliance status ID / appliance status ID.

I want to build a measure that tells me how many people have appliance 1 and in state 2, and at the same time have appliance 15 in state 3.

The person may have repeated appliances and in different states. I need to count the people who meet that condition

The table has such a shape

Id personaId applianceId state
111
112
1153
2151
211
312
312
3152

3

151
411
412
4151
4153

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Syndicated - Outbound

@Syndicate_Admin , Try a measure like

countx(filter(summarize(TABLE, Table[Id persona], "_1", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-1 && table[Id state] ?2))
, "_2", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-15 && table[Id state] ?3))) , [_1] >0 && [_2] >0 ), [Id persona])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

Syndicated - Outbound

@Syndicate_Admin , Try a measure like

countx(filter(summarize(TABLE, Table[Id persona], "_1", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-1 && table[Id state] ?2))
, "_2", calculate(count(Table[Id persona]), filter(Table, table[Id appliance]-15 && table[Id state] ?3))) , [_1] >0 && [_2] >0 ), [Id persona])

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Source Community: Power BI Spanish | Source Author Name: Maximiliano
Syndicated - Inbound

Thanks a lot!!! It was just what I needed!!!

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

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