Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 cont...
DAX
Help me please
Need Help DAX measure
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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"
    )
)
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    Perfect, thats exactly what I was looking for. 

    Much appreaciated.