Forum Discussion

amos_jevons's avatar
amos_jevons
Regular Visitor
7 years ago
Solved

Filter visuals based on slicer selection's parent category

I want users to be able to select an item from a slicer and see a report for all items in the same category.   I have a table similar to this:   COUNTRY | REGION | POPULATION | OEC...
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi amos_jevons,

     

    To achieve your requirement, create a measure using dax formula below:

    Result = 
VAR region = CALCULATE(MAX(Table1[REGION]), FILTER(ALL(Table1), Table1[COUNTRY] = SELECTEDVALUE(Table1[COUNTRY])))
VAR total = CALCULATE(SUM(Table1[POPULATION]), FILTER(ALL(Table1), Table1[REGION] = region))
return
CALCULATE(MAX(Table1[POPULATION]), FILTER(ALL(Table1), Table1[COUNTRY] = SELECTEDVALUE(Table1[COUNTRY]))) / total

     

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi amos_jevons,

 

To achieve your requirement, create a measure using dax formula below:

Result = 
VAR region = CALCULATE(MAX(Table1[REGION]), FILTER(ALL(Table1), Table1[COUNTRY] = SELECTEDVALUE(Table1[COUNTRY])))
VAR total = CALCULATE(SUM(Table1[POPULATION]), FILTER(ALL(Table1), Table1[REGION] = region))
return
CALCULATE(MAX(Table1[POPULATION]), FILTER(ALL(Table1), Table1[COUNTRY] = SELECTEDVALUE(Table1[COUNTRY]))) / total

 

 

Regards,

Jimmy Tao