topic Re: SUM total to change by date range selected on slicer in DAX Commands and Tips

SUM total to change by date range selected on slicer

Anonymous_ — Wed, 07 Feb 2024 15:58:17 GMT

Hello Team,

I want to calculate a SUM(Total clicks) such that it can change as and when my date slider changes.

And then, calculate " %linkclicks/Sum(total clicks)" such that this measure changes with the change in my date slider.

So, essentially I need the Clicks% column but I need both the Numerator and Denominator to change with change in dates (slider slicer)

Many Thanks!

Jihwan_Kim — Wed, 07 Feb 2024 18:08:33 GMT

Hi,

Please check the below picture and the attached pbix file.

Clicks measure: = SUM( Data[Clicks] )

Clicks % measure: = VAR _total = CALCULATE ( SUM ( Data[Clicks] ), ALLSELECTED ( 'Calendar'[Date] ) ) RETURN DIVIDE ( SUM ( Data[Clicks] ), _total )