topic Re: How to subset a table using slicer? in DAX Commands and Tips

How to subset a table using slicer?

Anonymous — Mon, 19 Oct 2020 20:43:31 GMT

I have the above dataset with two fields, QTR GTN % and QTR CV %

I need to create a slicer with these two columns with specific conditions for each.

For example, if I click on QTR GTN %, it will subset by table above to all rows with a QTR GTN % > 0.4 or QTR GTN % <-0.4.

If I click on QTR CV %, it will subset by table above to all rows with a QTR CV % > 0.1 or QTR GTN % <-0.1.

Once I make the selection on my slicer I want my graph of unique sales_doc_numbers by profit center to also change based on the new subset table. How do I do this?

Re: How to subset a table using slicer?

wdx223_Daniel — Tue, 20 Oct 2020 00:53:07 GMT

Anonymous think you can create a dim table and use it in a slicer, then use Switch or IF to control you calculation

or create a calculation group

Re: How to subset a table using slicer?

Anonymous — Tue, 20 Oct 2020 00:59:41 GMT

wdx223_Daniel Do you think you could provide a sample code on how to do this. I have tried to create another unrelated table and add a measure with an if statement but it's not working for me