cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sakthi Visitor
Visitor

Calculated Table filtered based on Slicer selection

I want to create table Filtered_Data based on table Data only for the selected values in the slicer.

 

Table Annual Medical Premium contains values 100000, 200000

 

So if i select 100000 in the slicer, i want the Data table to be copied to Filtered_Data table where Data[Annual_Premium] = 100000

 

I created a measure Premium_Selected = Min('Annual Medical Premium'[Annual_Premium])

Filtered_Data = Filter(Data,Data[Annual_Premium]=Data[Premium_Selected])

 

But i find the new table still contains data for both 100000 and 200000

 

however if change the expression as Filtered_Data = Filter(Data,Data[Annual_Premium]=100000), then the new table contains only the data for 100000.

 

Basically i have multitab report, so the slicer values in Page1, i want to pass to the Page2, i know only Report filters work across all pages, but i find slicer more user fiendly for end users, hence think of this workaround to have filtered data in the new table to be used for graphs in the Page2.

 

Not sure why the Measure is not filtering data during the table creation, any help is appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Calculated Table filtered based on Slicer selection

Hi @Sakthi,

 

The calculated table is preprocessed before use slicer visual to filter data. So we are not able to use the checked slicer value in the calculated table. Regrading filter all report page data, besides use Report Filter, you an also use Query Parameter.

 

The requirement about apply slicer filter on all report pages is under review, you can follow the survey share your thoughts: Allows Slicers to apply to all Pages of a Report.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Calculated Table filtered based on Slicer selection

Hi @Sakthi,

 

The calculated table is preprocessed before use slicer visual to filter data. So we are not able to use the checked slicer value in the calculated table. Regrading filter all report page data, besides use Report Filter, you an also use Query Parameter.

 

The requirement about apply slicer filter on all report pages is under review, you can follow the survey share your thoughts: Allows Slicers to apply to all Pages of a Report.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.