Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Adding Serial Numbers and Dynamic Filtering based on Slicer Selection

On Page 1, I have a slicer visual where I used the "Name" column from Table 2 On Page 2, I have a table visual where I used "Name" column from Table 1 and "Percentage" measure from Table 2. I would...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, Anonymous 
    You can create Index column in Power Query

     

     

    Use the sync slicer, and also use the slicer on the second page and hide

     

     

    Create a measure in Table2 and put it into the table visual you created, with the following DAX expression:

     

    Percentage Measure = 
var _currentName = MAX('Table1'[Name])
VAR _currentPercentage = CALCULATE(MAX('Table2'[Percentage]),FILTER(ALL(Table2),'Table2'[Name]=_currentName))
RETURN
IF(MAX('Table2'[Percentage])>=_currentPercentage,MAX('Table2'[Percentage]))

     

    Select slicer in Page 1 and here is my preview:

     

    How to Get Your Question Answered Quickly 

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous 
You can create Index column in Power Query

 

 

Use the sync slicer, and also use the slicer on the second page and hide

 

 

Create a measure in Table2 and put it into the table visual you created, with the following DAX expression:

 

Percentage Measure = 
var _currentName = MAX('Table1'[Name])
VAR _currentPercentage = CALCULATE(MAX('Table2'[Percentage]),FILTER(ALL(Table2),'Table2'[Name]=_currentName))
RETURN
IF(MAX('Table2'[Percentage])>=_currentPercentage,MAX('Table2'[Percentage]))

 

Select slicer in Page 1 and here is my preview:

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.