Forum Discussion

WOLFIE's avatar
WOLFIE
Icon for Helper I rankHelper I
4 years ago
Solved

Changing slicer condition to AND

Hi all,   I am trying to work this out for ages. I found many different solutions online, but nothing worked. It's a simple one table one slicer solution. I need to filter the ID by the selected ru...
  • amitchandak's avatar
    amitchandak
    4 years ago

    WOLFIE , Try Measure

     


    measure =
    var _cnt = calculate(DistinctCount('Table'[Rule]) ,allselected('Table'))
    return
    countx(filter(summarize('Table', 'Table'[ID], "_1", DistinctCount('Table'[Rule])),[_1]=_cnt),[ID])

     

     

    or

     

    measure =
    var _cnt = calculate(DistinctCount('Table'[Rule]) ,allselected('Table'))
    return
    calculate(countx(filter(summarize('Table', 'Table'[ID], "_1", DistinctCount('Table'[Rule])),[_1]=_cnt),[ID]), filter(allselected(Table), Table[ID] =max(Table[ID])))

  • WOLFIE's avatar
    WOLFIE
    4 years ago

    amitchandak Quick additional question 🙂 I need the table to keep all values when nothing is selected in the slicer. I tried this, but it doesn't work:

    measure =
    VAR _cnt = CALCULATE(DISTINCTCOUNT('Customer'[Rule]) ,ALLSELECTED('Customer'))
    RETURN
    IF(ISFILTERED(Customer),
    CALCULATE(
    COUNTX(
    FILTER(
    SUMMARIZE('Customer', 'Customer'[ID], "_1",
    DISTINCTCOUNT('Customer'[Rule])),[_1]=_cnt),[ID]),
    FILTER(ALLSELECTED(Customer),'Customer'[ID] = MAX('Customer'[ID])
    )
    ),1)
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

WOLFIE , Try Measure

 


measure =
var _cnt = calculate(DistinctCount('Table'[Rule]) ,allselected('Table'))
return
countx(filter(summarize('Table', 'Table'[ID], "_1", DistinctCount('Table'[Rule])),[_1]=_cnt),[ID])

 

 

or

 

measure =
var _cnt = calculate(DistinctCount('Table'[Rule]) ,allselected('Table'))
return
calculate(countx(filter(summarize('Table', 'Table'[ID], "_1", DistinctCount('Table'[Rule])),[_1]=_cnt),[ID]), filter(allselected(Table), Table[ID] =max(Table[ID])))

  • WOLFIE's avatar
    WOLFIE
    Icon for Helper I rankHelper I
    4 years ago

    The second one works! 🙂 Thanks so much!!!