Card shows 0 value No filter applying IF Statement Measure

[Chipsnump]

Hi,

I am creating the payment under the condition of minimun sales threshold with IF statement. The logic itself, is fine, but I would like to present the total payment in card without any filter applied.  As you see from below, without filter, it shows 0 as the total value, while showing a correct value when selected a specific shop. 

.

I tried both in order to test it, but it shows the same result which is 0 with no filter on.

Measure1:

Trusted_F =
VAR Ther_1 = 75000
VAR Ther_2 = 100000

VAR Ther_3 = 150000
RETURN
IF( [## Actual QTD] >= Ther_1 && [## Actual QTD] < Ther_2 , VALUE("1500") ,
IF( [## Actual QTD] >= Ther_2 && [## Actual QTD] <= Ther_3 , VALUE("2250") , "0"))

Measure2:

Trusted_F =
VAR Ther_1 = 75000
VAR Ther_2 = 100000

VAR Ther_3 = 150000
RETURN
IF( [## Actual QTD] >= Ther_1 && [## Actual QTD] < Ther_2 , 1500) ,
IF( [## Actual QTD] >= Ther_2 && [## Actual QTD] <= Ther_3 , 2250) , 0))

please advice.

[Anonymous · Accepted solution]

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.

[Ashish_Mathur · Accepted solution]

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.

[Kaviraj11]

Did 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

[Chipsnump]

Hi, 

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.

[Anonymous]

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.

[Anonymous]

Hi @Chipsnump 

I may have misjudged, but this DAX code doesn't seem to be a problem.

Please share your data(exclude sensitive data) or create some sample data, so that we can help you better.

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

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,

please find the pbix for your consideration. Normally, I would write the dax to set up the logic for the payment like this.

https://drive.google.com/file/d/1rWaEELvH8fTqyiEJ3TZXPRKQg5fVaoqC/view?usp=sharing 

[Ashish_Mathur · Accepted solution]

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.

[Chipsnump]

Thanks, it is working too 🙂

Cheer to this community. Thank you for your sharing.

[Ashish_Mathur]

You are welcome.

[Anonymous · Accepted solution]

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.

[Chipsnump · Accepted solution]

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