Forum Discussion
Need help with DAX expression
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.
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" ) )
2 Replies
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" ) )