Forum Discussion

suvechha's avatar
suvechha
Helper 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.

2 Replies

  • BeaBF's avatar
    BeaBF
    Super User
    4 years ago

    suvechha  Hi!
    Could you explain better the expected result? Perhaps also providing an example of the data on which to calculate the measure.

    B.

  • v-robertq-msft's avatar
    v-robertq-msft
    Community 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.