topic Re: Need help with DAX expression in DAX Commands and Tips

Need help with DAX expression

Anonymous — Mon, 29 Aug 2022 20:41:13 GMT

Hello,

I really need help with DAX expression to get below result:

Store with Only Online machines should contain all machines with "Online" status.

Store with Only Offline machines should contain all machines with "Offline" status.

Thanks in advance.

Jihwan_Kim — Tue, 30 Aug 2022 03:43:20 GMT

Hi,

Based on the table structure that I see on the screenshot, I tried to create measures like below.

Please check the below picture and the attached pbix file.

Stores with only online: = COUNTROWS ( FILTER ( VALUES ( Data[Store Name] ), CALCULATE ( SELECTEDVALUE ( Data[Machine Status] ) ) = "Online" ) )

Stores with only offline: = COUNTROWS ( FILTER ( VALUES ( Data[Store Name] ), CALCULATE ( SELECTEDVALUE ( Data[Machine Status] ) ) = "Offline" ) )

Anonymous — Tue, 30 Aug 2022 13:54:33 GMT

Perfect, thats exactly what I was looking for.

Much appreaciated.