Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

To select multiple values from slicer : customised

Hi,   I have a table with attributes of customer.  I have a customised slicer to get the count of rows where the value is > 0:- I have used the column name :- no. of prod1 only,no. of prod2 only, ...
Need Help
Need Help DAX
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    You can try this way:

    Dynamic column = 
var _selectedfunction=VALUES(Custom_slicer[Slicer])
return
    if( "no. of prod1 only" in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of prod1 only] >0)))+
    if( "no. of prod2 only"  in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of prod2 only] >0))) +
    if( "no. of prod 1 and 2"  in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of prod 1 and 2] >0)))+
    IF( "no. of other"  in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of other] >0)))
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

You can try this way:

Dynamic column = 
var _selectedfunction=VALUES(Custom_slicer[Slicer])
return
    if( "no. of prod1 only" in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of prod1 only] >0)))+
    if( "no. of prod2 only"  in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of prod2 only] >0))) +
    if( "no. of prod 1 and 2"  in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of prod 1 and 2] >0)))+
    IF( "no. of other"  in _selectedfunction , COUNTROWS(CALCULATETABLE(TableA,TableA[no. of other] >0)))