Forum Discussion
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 chart selection portion of model vs rest order count present in model version.
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
13 Replies
- Fowmy
Super User
navneet0512I have older version power bi can you please explain here
- Fowmy
navneet0512
The file that I shared should work in any version, what's the version of Power BI are you using?
- Ritaf1983
Hi navneet0512
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- navneet0512
In pie chart I want to see the count of order selected in filter (Model version) vs rest entire count of model version. It should change dynamically as filter modern version selection.
- Ritaf1983
I'll be glad to assist, but need data to work with ...
