Forum Discussion

Klasia's avatar
Klasia
Frequent Visitor
1 year ago
Solved

Dynamic quantile calculation and matrix marking

Hi. I have in my Power BI matrix, where from each category and type I want show in which row i have median and quantiles (0,25; 0,95). All value in time I have coating in measure because must be din...
Need Help
Show and Tell
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi Klasia,

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    Thank you pankajnamekar25, for your valuable insights.

    I have reproduced the scenario using sample data. Please find the attached pbix file for your reference.

     

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.

Klasia's avatar
Klasia
Frequent Visitor
1 year ago

Thanks pankajnamekar25 , but I don't know what I do wrong in Median Time, because show me wrong value

And I do exactly how you wrote

 

EDIT: I chage ALLEXCEPT to  ALLSELECTED and now working. 

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi Klasia,

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    Thank you pankajnamekar25, for your valuable insights.

    I have reproduced the scenario using sample data. Please find the attached pbix file for your reference.

     

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

     

    Thank you.

    • v-saisrao-msft's avatar
      v-saisrao-msft
      Community Support
      1 year ago

      Hi Klasia,

       

      We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

       

      Thank you.

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Community Support
    1 year ago

    Hi Klasia,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.