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]))

Vladislav_1986's avatar
Vladislav_1986
Frequent Visitor
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]))

jimmyswoosh's avatar
jimmyswoosh
Icon for Advocate I rankAdvocate I
7 years ago

Hi Vladislav_1986,

 

I'm reading through your issue and seems like I have a similar problem. Can you elaborate on what 'ColumnPK' is and what values are in it?

 

Thanks!