Summarise data in a card, using DAX measure as a filter

[tiffanyt123]

Hi! I am trying to summarise data into a card using a filter that is a DAX measure.

In a table form, the data is correct (i am able to filter using the DAX measure, committed indicator = 1)

However, the issue comes when i am trying to summarise it in a card - i am unable to add the DAX measure as my filter 😞

Can someone help on this please? Basically I just want the sum of the card to tally with the total in the table.

Any help would be greatly appreciated - attached is the file :))

[FreemanZ · Accepted solution]

hi @tiffanyt123 

try like:

Area =
CALCULATE(
    SUM(TableName[Occupancy Area]),
    FILTER(TableName, [Committed_Indicator]=1)
)

in case of issue, please paste the code for the Committed_Indicator measure.

[tiffanyt123]

Thanks so much!!! that has worked for now :))