Forum Discussion
Helper IIIOrder number as per filter selection
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
Super UserHi 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
Helper IIIIn 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 ...
- Ritaf1983
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