BUY and SELL based on country

[Kannan4444]

I have my dataset in below format. i want to see the BUY and SELL for China in one chart. can you please help?

Example: Jan month - China has export 200 and imports 300

[v-jianboli-msft · Accepted solution]

Hi @Kannan4444 ,

Please try:

First create a table for slicer and turn the single select on:

For slicer = DISTINCT( UNION( SUMMARIZE('Table',[Load Country]),SUMMARIZE('Table',[Discharge Country])))

Output:

Then create the following measures:

Export = CALCULATE(SUM('Table'[Voulme]),FILTER('Table',[Load Country]=SELECTEDVALUE('For slicer'[Country])))

Imports = CALCULATE(SUM('Table'[Voulme]),FILTER('Table',[Discharge Country]=SELECTEDVALUE('For slicer'[Country])))

Apply them to the visual:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[gauthamboppana]

@Kannan4444  -  Refer to this sample pbix file. Let me know if you have any questions.

1. In Power Query, transpose your data as below.

2. Create two measure as below

Exports = CALCULATE(sum('Table'[Volume]),'Table'[Country Type] = "Load Country")

Imports = CALCULATE(sum('Table'[Volume]),'Table'[Country Type] = "Discharge Country")

3. Now use these measure in the visuals.

Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

Thank you very much !

[Kannan4444]

can you please share the Pbix file please