Show a card calculation depending on column

[Syndicate_Admin]

good.

I think it's a simple thing, but I can't get it to work for me in Power Bi, I want to put a card that according to one IF shows one type of measure or another.

The problem I have in the table that I want to compare, I want if the value of a column is to 0 I will show a sum(total19) and if this to 1 shows an average(Average19). The idea is like this:

Card - If (Type-0, Total19, Average19)

Total - SUM(Rows[Value])

Total19 - CALCULATE([Total], Rows[Year]-2019)

Average19 ? AVERAGEX(Rows,[Total19])

Thanks a lot.

a greeting

[v-henryk-mstf · Accepted solution]

Hi @Syndicate_Admin ,

According to the test file you provided, I did the following test:

Result =
VAR a =
    CALCULATE ( SUM ( Hoja1[Valor] ), FILTER ( ALL ( Hoja1 ), Hoja1[Año] = 2019 ) )
VAR b =
    CALCULATE (
        AVERAGE ( Hoja1[Valor] ),
        FILTER ( ALL ( Hoja1 ), Hoja1[Año] = 2019 )
    )
RETURN
    IF ( MAX ( Hoja1[Tipo] ) = 1, a, b )

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

Below is test pbix file.

[amitchandak]

@Syndicate_Admin , do need something like a measure slicer ?

refer my video if that can help

How to create a Measure Slicer: https://youtu.be/b9352Vxuj-M

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Syndicate_Admin]

Hello I have created an example, it is simple, a single table in which I have two filters, and what I want on a single card, that if it is type 1 show me the total and if the type 0 shows me the average

example

Thank you