Order number as per filter selection

[navneet0512]

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.

[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 ...

[Ritaf1983 · Accepted solution]

@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 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

[Fowmy]

@navneet0512 
Refer the attached example that I have shared:

[navneet0512]

I 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?

[navneet0512]

January(2022)

[Fowmy]

@navneet0512 

Please the file, I made a change.

[navneet0512]

Still the same 

[Fowmy]

@navneet0512 

Download the latest version

[navneet0512]

I can't as my azure power bi services is restricted . 

[Fowmy]

@navneet0512 

You can download Power BI desktop without any restriction of Azure. Please use below link:

Download Power BI Desktop from Official Microsoft Download Center