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.