Forum Discussion

Vladislav_1986's avatar
Vladislav_1986
Frequent Visitor
9 years ago
Solved

Dynamic filtering of table

Hello,   Could you, please, help me with the question of dynamic filtering.   I have table like this:   Item ID    Column    Duration   Project 1               New           10          A  2 ...
  • Vladislav_1986's avatar
    Vladislav_1986
    9 years ago

    Hi, I have created filtering by formula and added column with value for every pair of Projects and Columns:

     

    Column 2 = CALCULATE(PERCENTILE.INC('PBIs Duration'[Sum Duration],0.9), FILTER('PBIs Duration', EARLIER('PBIs Duration'[ColumnPK]) = 'PBIs Duration'[ColumnPK] && EARLIER('PBIs Duration'[TeamProject])='PBIs Duration'[TeamProject]))

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Vladislav_1986,

Please try to add ALLSELECTED in measure [Percentile 90], and check if it works fine.

Percentile 90 = CALCULATE(PERCENTILE.INC('PBIs Duration'[Sum Duration],0.9),'PBIs Duration'[Sum Duration]<>0,ALLSELECTED('PBIs Duration'))


Best Regards,
Angelia

Vladislav_1986's avatar
Vladislav_1986
Frequent Visitor
9 years ago

Hello!

 

Thank you. I have just tried - still the same behaviour. The new table is filtered by the initial value of masure, filtering on dashboard doesn't affect the formula.