Forum Discussion
navneet0512
Helper III
Helper IIIOrder number as per filter selection
I want to know the approch for below problem:- I want to see the count of version selected in model version in chart for rest order count in model version will be like "Nav" or any name . Means pie...
navneet0512
If your database is something in the style of :you can create 2 measures :
1. for counting orders of selected model :selected_model_count =DISTINCTCOUNT('Table'[order id])2. for counting the difference from all the othersDiff_from_all = CALCULATE(DISTINCTCOUNT('Table'[order id]),all('Table'[model]))-[selected_model_count]and then put these measures on pie "
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Ritaf1983
Super User
Super UserI'll be glad to assist, but need data to work with ...
Ritaf1983Super User
Super Usernavneet0512
If your database is something in the style of :
you can create 2 measures :
1. for counting orders of selected model :
selected_model_count =
DISTINCTCOUNT('Table'[order id])
2. for counting the difference from all the others
Diff_from_all = CALCULATE(DISTINCTCOUNT('Table'[order id]),all('Table'[model]))-[selected_model_count]
and then put these measures on pie "
PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly