Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

pb version

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,

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

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])

11.PNG 

 

Regards,

Jimmy Tao

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

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])

11.PNG 

 

Regards,

Jimmy Tao

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.