Dax expression help required.

[suvechha]

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 · Accepted solution]

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.

[BeaBF]

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

B.