Forum Discussion
Solved
Multiple Slicer with AND Logic
I wonder if anyone can help, i have been going around in circles with this one for days. I will try to explain as best as i can this is an example data table i have i want to buil...
Try this:
1. Create calculated table (no relationships):
SalesPersonSlicer = DISTINCT ( salesorder[Sales Person] )2. Create a slicer using SalesPersonSlicer.
3. Create measure:
OrdersDeliveredBySalespersonAndStage = VAR vOrderCounts = ADDCOLUMNS ( VALUES ( salesorder[Order] ), "@RowCount", CALCULATE ( COUNTROWS ( salesorder ) ), "@RowCountSalesPerson", CALCULATE ( COUNTROWS ( salesorder ), TREATAS ( VALUES ( SalesPersonSlicer[Sales Person] ), salesorder[Sales Person] ) ) ) VAR vResult = COUNTROWS ( FILTER ( vOrderCounts, [@RowCount] = [@RowCountSalesPerson] ) ) RETURN vResult
Try this measure:
OrdersDeliveredBySalespersonAndStage =
IF ( DISTINCTCOUNT(salesorder[Sales Person]) > 1, 0, 1 )
-----