pb version

[Anonymous]

Hello everyone,

I got one more problem

I got one data table like this :

No      Archived       Amount        Amount Arch     Measure

Ord1   NO                10€               0€                       10€

Ord2   NO                10€               0€                       10€

Ord2   YES                0€                5€                        5€

Ord3   YES                0€                12€                      12€

Total                          20€              17€                      32€

Don't tell me why there are several orders which are NO and Archived at the both time this is a fact. I don't know why.

So, I don't want the order2 archived on the total.

Today I made a table like this :

No      Amount        Amount Arch     Measure

Ord1   10€               0€                       10€

Ord2   10€               5€                       10€

Ord3   0€                12€                      12€

Total    20€              17€                      20€

With measure = If amount=0 ; amount arch ; amount) but the total is false (it is not what I want).

Do you have an issue about that?

Thanks for all,

[v-yuta-msft · Accepted solution]

Hi bapt69,

To achieve your requirememt, you can create a calculate column instead using DAX below:

Column = IF(Table1[Amount] = 0, Table1[Amount Arch], Table1[Amount])

 

Regards,

Jimmy Tao