topic Re: summarized data in Report Server

summarized data

Rocky_Brown — Thu, 26 Aug 2021 15:45:47 GMT

I have a report that summarizes data based on Year, Qurter and Month. A have slicers for all 3 elements. Is there a way to display the summed data to reflect the last month's figures when selecting just the Quarter slice and not the month slicer?

Re: summarized data

lbendlin — Sun, 29 Aug 2021 20:32:49 GMT

Please specify if this is for Report Server or for the Power BI Service.

Please provide sample data in usable format (not as a picture - maybe insert into a table?) and show the expected outcome.

Re: summarized data

Icey — Mon, 30 Aug 2021 09:05:26 GMT

Hi Rocky_Brown ,

I create a sample, please check if this is what you want:

LastMonthData filtered by Quater = IF ( ISFILTERED ( 'Table'[Date].[Quarter] ) && NOT ( ISFILTERED ( 'Table'[Date].[Month] ) ), CALCULATE ( SUM ( 'Table'[Value] ), FILTER ( ALL ( 'Table' ), 'Table'[Date] > EOMONTH ( MIN ( 'Table'[Date] ), -2 ) && 'Table'[Date] <= EOMONTH ( MIN ( 'Table'[Date] ), -1 ) ) ) )

In this sample, it returns blank when filtered by Date.Month. In you scenario, you can set what you want when filtered by Date.Month.

Best Regards,

Icey

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