To sum based on half-yearly field and slicer selection

[jenani_user]

Hi Team,

Kindly suggest dax to calculate total based on half-yearly, the input and output are as shown in image.

The total has to be displayed based on year and category slicer selection

Thanks,

Jenani

[v-luwang-msft · Accepted solution]

HI @jenani_user ,

Pls create the below measure:

sumvalue = CALCULATE(SUM('Table'[overall]),ALLSELECTED('Table'),'Table'[Half-yearly]=MAX('Table'[Half-yearly]))

Outputresult:

You could download my pbix file to learn more details.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien