Assign a value to a field depending on a condition and display the column total

[Syndicate_Admin]

Good team I would like to help me with the following situation:

I have 2 measures called Sales 2021 and Sales 22. I made a measure called opportunity 2022 in which I want to put the sales of the products that were sold in 2021 but in 2022 they were not had. This measure gives me what I want to do but does not show me the total.

Opportunity 2022 = CALCULATE(IF([Sales 2022]=0,[Sales 2021]))

As you can see it does not show me the total and I would like it to appear.

Thank you for your help

[v-jianboli-msft · Accepted solution]

Hi @Syndicate_Admin ,

Based on your description, I have created a simple sample:

Please try:

Measure = 
var _a = SUMMARIZE('Table','Table'[ID],'Table'[Sales 2021],'Table'[Sales 2022],"value",IF([Sales 2022]=0,[Sales 2021]))
return SUMX(_a,[value])

Final output:

Best Regards,

Jianbo Li

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

[Ashish_Mathur]

Hi,

Share the download link of your PBI file.