Assign a value to a field depending on a condition and display the column total
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.