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, as I didn't found the way how to connect filter from dashboard, I decided to do pre-filtering in formula in calculated column. One more complex step, but it works.

 

Thank you.

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

    Hi Vladislav_1986,

    Congratulations, please mark your workaround as answer, so more people will benefit from here.

    Best Regards,
    Angelia

    • 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!