pb version

Question

Hello everyone,I got one more problem&nbsp;I got one data table like this :No&nbsp; &nbsp; &nbsp; Archived&nbsp; &nbsp; &nbsp; &nbsp;Amount&nbsp; &nbsp; &nbsp; &nbsp; Amount Arch&nbsp; &nbsp; &nbsp;MeasureOrd1&nbsp; &nbsp;NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10€Ord2&nbsp; &nbsp;NO&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10€Ord2&nbsp; &nbsp;YES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5€Ord3&nbsp; &nbsp;YES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12€Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 32€&nbsp;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.&nbsp;Today I made a table like this :No&nbsp; &nbsp; &nbsp; Amount&nbsp; &nbsp; &nbsp; &nbsp; Amount Arch&nbsp; &nbsp; &nbsp;MeasureOrd1&nbsp; &nbsp;10€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10€Ord2&nbsp; &nbsp;10€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10€Ord3&nbsp; &nbsp;0€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12€Total&nbsp; &nbsp; 20€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 17€&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20€With measure = If amount=0 ; amount arch ; amount) but the total is false (it is not what I want).&nbsp;Do you have an issue about that?Thanks for all,

v-yuta-msft · Accepted Answer

Hi&nbsp;bapt69,
&nbsp;
To achieve your requirememt, you can create a calculate column instead using DAX below:
Column = IF(Table1[Amount] = 0, Table1[Amount Arch], Table1[Amount])
&nbsp;
&nbsp;
Regards,
Jimmy Tao

Forum Discussion

pb version

1 Reply

Related content

Version control

DATESYTD problem in PB Onpremises (Remote Server)

CountIf in PB

Fabric Warehouse - table versions

Is ADF Fabric version compactable with Github Proxima on version control?