How to make selected country as reference country for calculation?

[Likhitha]

I'm having a funnel chart which shows sales by country, top sales country will be taken as 100%,I want to take some other country sales% as 100% and want to calculate the sales of other countries.

[v-lili6-msft]

HI, @Likhitha 

Based on my research, it does not keep the top sales country as 100%,

it is based on the sort order of the visual

for example:

So you could use this way as below:

Step1:

Add an index column for country field.

Step2:

Darg this index column into tooltips value or use Sort by column in Power BI Desktop

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Best Regards,

Lin

[Likhitha]

@v-lili6-msft  In my case,I will use slicer for country,the selected country sales % has to be taken as 100% and has to give sales % of other countries.

[v-lili6-msft]

HI, @Likhitha 

If you use slicer for country, when you selected one country, other countries will be filtered, how to use it to refer to others.

Best Regards,

Lin

[Likhitha]

@v-lili6-msft  For example ,I want to take australia sales as 100% and want to see other countries sales% with respect to that..is it possible??

[v-lili6-msft · Accepted solution]

hi, @Likhitha 

You could try this way to get it:

Step1:

Add a new table by this formula for slicer

Do not create the relationship with other tables ( just for keep which country is as 100%  )

Refer country = VALUES('Table'[Country])

Step2:

Add a measure like this then drag it into tooltips value

Measure = IF(SELECTEDVALUE('Table'[Country]) in VALUES('Refer country'[Country]),1)

Step3:

Sort the visual by this measure

Result:

and here is pbix file please try it.

Best Regards,

Lin

[Likhitha]

@v-lili6-msft  Thank you..it's working..:)

[Likhitha]

@v-lili6-msft  Hi...I'm having some doubt regarding the above question...I want to make one country to be fixed at the top and want to comapre all other countries w.r.to fixed country.How to do that??

---