Create a slicer that filters summarised (sum) values

[kotlonarendra]

I have the dataset as below

Email Address	Dept ID	Alias	Emp Id	Voice Mins	SMS Msgs	# of Pages	Dispatch Mins	Data KB	Currency	Total Charges
xyz@gmail.com	43425		903618	7	6	0	0	14583798	USD	115.94
xyz@gmail.com	43425		903618	4	4	0	0	8931175	USD	68.25
xyz@gmail.com	43425		903618	39	1	0	0	7964692	USD	57.56

In the table visual I would group and summarise this data grouped by Invoices and sum of total charges.

Email Address	Dept ID	Alias	Emp Id	Voice Mins	SMS Msgs	# of Pages	Dispatch Mins	Data KB	Currency	Total Charges	Number Of Invoices
xyz@gmail.com	43425		903618	7	6	0	0	14583798	USD	241.75	3

Now I want to create a slicer for Total Charges >= input value.

When i input the slicer to filter for values >= 160, it should show me the summarised data as

Email Address	Dept ID	Alias	Emp Id	Voice Mins	SMS Msgs	# of Pages	Dispatch Mins	Data KB	Currency	Total Charges	Number Of Invoices
xyz@gmail.com	43425		903618	7	6	0	0	14583798	USD	241.75	3

Instead I am getting no result, that is becasue it is applying filter on the original data set and not the sum of the grouped data.

It is checking for the total charges (115.94,68.25,57.56) and not the summed value shown in the table visual which is 241.75

Is there a way to get the slicer to filter values but on the grouped and summed data?

[kotlonarendra]

Thanks @Fowmy ,

This did not work, it still does not filter on the sumed total.

[Fowmy]

@kotlonarendra 

I am not sure how you implemented the proposed solution. 

Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.

[kotlonarendra]

Sure, let me prepare the data and send it you via GDrive

[Anonymous]

Hi, @kotlonarendra 
Thanks for reaching out to the Microsoft fabric community forum.

Do you have any updates on the results? We are very concerned about your issue. If the problem is not yet resolved, we hope you can provide your test data so that we can better understand your data structure and test our solution. You can share the data with us using GitHub, as we might not be able to open GDrive links.

If the issue has been resolved, we also welcome you to share your solution, as it can help other members in the forum who have similar issues find a solution.

Thank you for your cooperation!

Best Regards,

Leroy Lu

[Fowmy]

@kotlonarendra 

One of option is to create a DAX calculated table as follows and use the Total Charges column on the slicer to filter.

SummarizedTable = 
SUMMARIZE(
    'YourTable',
    'YourTable'[Email Address],
    'YourTable'[Dept ID],
    'YourTable'[Alias],
    'YourTable'[Emp Id],
    'YourTable'[Voice Mins],
    'YourTable'[SMS Msgs],
    'YourTable'[# of Pages],
    'YourTable'[Dispatch Mins],
    'YourTable'[Data KB],
    'YourTable'[Currency],
    "Total Charges (Sum)", SUM('YourTable'[Total Charges]),
    "Row Count", COUNTROWS('YourTable')
)