Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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.
Solved! Go to Solution.
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"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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"
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Perfect, thats exactly what I was looking for.
Much appreaciated.
Check out the November 2023 Power BI update to learn about new features.