Sum data based on product availability by comparing years.

[Sudharsanan]

Hi All,

Can someone help me with the below scenerio?

I wanted to sum the price when the product is available on both 2022 and 2021? is this something we can get using DAX?

Appreciate your support!!

[SpartaBI]

@Sudharsanan what is the result you want to get in the measure?
25 + 35 + 45 ? or also the valus from 2022? 5, 10 and 20?

[Sudharsanan]

@SpartaBI i need 25+35+45 from 2021 alone

[SpartaBI · Accepted solution]

@Sudharsanan 

Result = 
VAR _filter = 
INTERSECT(
    CALCULATETABLE(VALUES('Table'[Customer]),'Table'[Year] = 2021),
    CALCULATETABLE(VALUES('Table'[Customer]),'Table'[Year] = 2022)
)
RETURN
CALCULATE(
    SUM('Table'[Price]),
    'Table'[Year] = 2021,
    _filter
)

      

Showcase Report – Contoso By SpartaBI

[Sudharsanan]

@SpartaBI   I am getting the below error and not able to get the answer..can you help me with it?

[SpartaBI]

@Sudharsanan you didn't share the screenshot or I can't see it for some reason

[Sudharsanan]

am sorry @SpartaBI  the error is not showing now which was related to values..somehow i fixed it..but the result is blank now

[SpartaBI]

@Sudharsanan hey friend, will be back to desk in few minutes. Do you want to do a quick zoom?

[Sudharsanan]

@SpartaBI thats should be better..let me know how can i connect?

[SpartaBI]

@Sudharsanan can you join now?
https://us05web.zoom.us/j/82871748787?pwd=bFBCenRWK1g4ZkhWR3U4cndvUmtXQT09

[Sudharsanan]

@SpartaBI meet.google.com/kbh-uyud-dvz