topic Re: CUMMULATIVE RESULT WITH PLAY AXIS SLICER in DAX Commands and Tips

CUMMULATIVE RESULT WITH PLAY AXIS SLICER

Yaswanth1997 — Sat, 24 Jun 2023 12:34:39 GMT

Hii Power BI Community ,

Please Help me Out of this Scenario,

I had a data which includes address Field & Establisted date

& the Requirement was i want to show all addresses in Global map based on Play Slicer

( Which Means the Addresses need to be Shown based on date )

But the Problem is Play axis will filtering One date to another date

But My Requirement was i want

( Eg: if i have year : 2020 to 2023 then from 2020 to cummulatively the addresses need to be shown in Global map )

anyone please help me out this case How to do ????

Re: CUMMULATIVE RESULT WITH PLAY AXIS SLICER

Anonymous — Mon, 26 Jun 2023 01:57:33 GMT

Hi Yaswanth1997 ,

Please try this formula:

Cumulative Result = CALCULATE( [Result], FILTER( ALLSELECTED('Table'[Date]), 'Table'[Date] <= MAX('Table'[Date]) ) )

Replace Result with the name of the column that contains the addresses, and replace Table with the name of the table that contains the data. You can use this measure in a map visual with a play axis slicer to show the addresses cumulatively based on the date range.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.