Forum Discussion

atat0105's avatar
atat0105
New Member
9 years ago
Solved

Set Values For Slicer

Hello everyone,   I have a column which defines each row like below.   Column =IF(V_OKM_0[Periyod]<601;"Active";"Passive")   then, I show percentage of "Passive" on a card.   Measure = CALCUL...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi atat0105,

     

    It is possible, you can refer to below steps:

    Tables: Sheet1,sheet2.


     

    Measures:

     

    Sheet2.


    Select value:
    Select value = if(HASONEVALUE(Sheet2[Amount]),VALUES(Sheet2[Amount]),BLANK())

     

    Sheet1.


    Get the status of select values:
    Active Status = IF(max([Amount])<[Select value],"Active","Passive")

     

    Percent of passive:
    Percent of Passive = COUNTAX(FILTER(ALL(Sheet1),[Active Status]="Passive"),[ID])/COUNTROWS(ALL(Sheet1))

     

    Create visuals.

    Table:


     

    slicer:

     

     

    card:

     


     

    Result:
      


    Regards,
    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi atat0105,

 

It is possible, you can refer to below steps:

Tables: Sheet1,sheet2.


 

Measures:

 

Sheet2.


Select value:
Select value = if(HASONEVALUE(Sheet2[Amount]),VALUES(Sheet2[Amount]),BLANK())

 

Sheet1.


Get the status of select values:
Active Status = IF(max([Amount])<[Select value],"Active","Passive")

 

Percent of passive:
Percent of Passive = COUNTAX(FILTER(ALL(Sheet1),[Active Status]="Passive"),[ID])/COUNTROWS(ALL(Sheet1))

 

Create visuals.

Table:


 

slicer:

 

 

card:

 


 

Result:
  


Regards,
Xiaoxin Sheng