Card shows 0 value No filter applying IF Statement Measure

Hi Chipsnump 

Here I create a measure:

MEASURE =
VAR _vtable =
    SUMMARIZE (
        'Custoemr',
        'Custoemr'[Group Name_2],
        "_ActSales", [Actual_Sales],
        "_Crteria", [Criteria 1]
    )
RETURN
    SUMX ( _vtable, [_Crteria] )

Add it into a card, the result is as follow:

Best Regards

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

Hi,

I do not know what result you want.  Furthermore, when i opened the file, i got 10,000 as the answer in the card visual (not a 0).  Anyways, drag this measure to the table and card visual

Measure = SUMX(VALUES(Custoemr[Group Name_2]),[Criteria 1])

Hope this helps.

I made it, thank you so much for your kind support and advice 🙂