Show but dont sum it is possible ?

[Cobra77]

Hi,

In column 1 , the data in the table but the total is false 55 000

In column 2 , the measure who filter on statut  = true , with the good Total but dont show values 5000 line 2 

In column 3 , if I have to take into account in the calculation

We want : 

line  1 : 50 000

line 2 : 5 000

Total : 50 000

An idea ?

Thanks

[Anonymous]

HI @Cobra77,

You can use below measure to replace amount column to create visual:

Measure =
CALCULATE ( SUM ( TABLE[Amount] ), Table[Conditon] = "True" )

Regards,
Xiaoxin Sheng

[Cobra77]

Hi @Anonymous

its the measure ( column 2 ) your formule , but with this no show 5000 line 2

Regards,

[Anonymous · Accepted solution]

Hi @Cobra77,

I modify my formula to add if statement to only ignore summarize specific values on total level:

Measure =
IF (
    COUNTROWS ( Table ) <> COUNTROWS ( ALLSELECTED ( Table ) ),
    SUM ( Table[Amount] ),
    CALCULATE ( SUM ( Table[Amount] ), Table[Conditon] = "True" )
)

Regards,

Xiaoxin Sheng

[Cobra77]

Hi @Anonymous

Thanks , perfect 😉