Calculate percentiles for 2 graphs in same visual

[wokka]

Hi

I have a line graph that has 2 lines in the one visual - one for SYD and one for MEL , which are different.

The Y axis has a value of  "Entry" , the X axis has value  "Days"

What I want to do is use DAX to pull the same data that was used to create the graphs, but then analyse the data for SYD and MEL to calculate a median values for the SYD and MEL line graphs, and then store it in variables ( or something else ? ) so I can add variables as the two median values as 2 X-Constant lines on the graph. If I dont handle the data separately I see only one median line for SYD and MEL.

I know the tables i need to access to get the data, and thought of using a FILTER and RELATED command to select the data based on MEL or SYD.

I can see what I want to do, just need assistance on how to construct the solution 🙂

Any help appreciated.

[v-priyankata]

Hi @wokka 
We have successfully transferred this thread to DAX. I have reproduced the issue based on your inputs, please review it and let us know if it works for you. If you are still experiencing any issues, feel free to reach out here. We're happy to help.

Thanks.

[v-priyankata]

Hi @wokka 

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @wokka 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @wokka 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[v-priyankata]

Hi @wokka 

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

@FBergamaschi Thanks for the words.
As suggested by @FBergamaschi please delete the post here and repost it in DAX Commands and Tips.
Please try to post your question along with the sample data so we can work on it. We will do our best to provide a solution and we are happy to help.

Thanks.

[wokka]

Hi, I dont seem to have a delete option.

[FBergamaschi]

This post contains a DAX question, please delete this post and repost it
here

When you repost it

Please include, in a usable format, not an image, a small set of rows for each of the tables involved in your request and show the data model in a picture, so that we can import the tables in Power BI and reproduce the data model. The subset of rows you provide, even is just a subset of the original tables, must cover your issue or question completely. Do not include sensitive information and do not include anything that is unrelated to the issue or question. Please show the expected outcome based on the sample data you provided and make sure, in case you show a Power BI visual, to clarify the columns used in the grouping sections of the visual.

Need help uploading data? click here

Want faster answers? click here