Forum Discussion
Advocate ICard 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 🙂
Solution SageDid you consider the 'Edit Interaction' feature? This will solve your problem.
Steps:
1. Enable the Edit Interaction
2. Select the visual(table or matrix)
3. Make sure the 'Impact button' is Shaded on the card visual.
Change how visuals interact in a report - Power BI | Microsoft Learn
ChipsnumpHi,
Thank you for your reply.
It's not about no impact filter to the table or the matrix. But I actually would like to set a default of Card Visualization to be total amount of this measure instead of "0". I believe that the card may retreive this measure as the text rather than number, so that's why it represents either 0 or the maximum value from this measure.
HI Chipsnump
I speculate that the problem could be caused by the measure: [## Actual QTD].
Could you please let me check how this measure is written, that could be more careful to solve your problem.
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.- Chipsnump
Hi
thank you for your reply,[## Actual QTD] = sum(fact_sales_data(net amount))
and select all month from date table.
it shows 0 as the default value again.