Forum Discussion

kotlonarendra's avatar
kotlonarendra
Frequent Visitor
1 year ago

Create a slicer that filters summarised (sum) values

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 [email protected] 434...
Need Help
Tips and Tricks
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

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')
)