Need to sum up the planned value based on condition

[Anonymous]

Hi Everyone,

I have one scenario,

1.whenever i select month in within quarter then it should display : 15

2.Whenever i select two months in different quarter then it should display : 30

Please help me with this scenario.please see the attached image for data and requirement.

[Anonymous · Accepted solution]

Hi @Anonymous,

You can try below measure formal to work with date filter, it will summary records based on year an quarter and auto remove duplicate records:

Meaure =
SUMX (
    SUMMARIZE ( ALLSELECTED ( Table ), [Year], [Quarter], [Planned] ),
    [Planned]
)

Regards,

Xiaoxin Sheng

[selimovd]

Hey @Anonymous ,

what exactly do you mean with "when you select" and how should your result look like?

Do you select in a slicer? Do you select a row? What do you display?

And please show the result how it should look like.

Thank you and best regards

Denis

[Anonymous]

Hi,

as i said, year and months are slicers.if you see the image in that there is requirement. so could you please help me out.