Forum Discussion

suvechha's avatar
suvechha
Icon for Helper IV rankHelper IV
4 years ago
Solved

Dax expression help required.

Hi there, How to add this in Measure table in Power BI App -   sum({1<Facility={"RNSH","HKH","RYD","NBH","MV"}>}0) Thanks
  • v-robertq-msft's avatar
    v-robertq-msft
    4 years ago

    Hi, 

    According to your description, I can roughly understand your requirement, I’ve created some test data to use a measure to achieve your requirement, you can try this measure:

    This is the test data I created:

     

    Result =

CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),[Facility] in {"RNSH","HKH","RYD","NBH","MV"}&&[Amount]>=0&&[Amount]<1))

     

    And you can create a card chart to place this measure to get what you want:

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, 

According to your description, I can roughly understand your requirement, I’ve created some test data to use a measure to achieve your requirement, you can try this measure:

This is the test data I created:

 

Result =

CALCULATE(SUM('Table'[Amount]),FILTER(ALL('Table'),[Facility] in {"RNSH","HKH","RYD","NBH","MV"}&&[Amount]>=0&&[Amount]<1))

 

And you can create a card chart to place this measure to get what you want:

 

You can download my test pbix file below

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.