Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
ngocnguyen
Helper IV
Helper IV

CONNECTION

hi,

I have 2 input data like Actual and BP table below

Now I wanna create a slicer : POL and POD  => If I choose slicer: POL = PKL, POD = HCM

I can get the below results as Output table

In which, Qty = total qty in Actual Table

BP get from BP table

Compare = % QTY- BP

 

pls help me. thanks alot

 

 

 

 

 

 

Capture2.PNG

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @ngocnguyen ,

 

The result is this.

1.png

 

The method is to summarize all possible results of the Carrier, POL, and POD columns of the two tables into one table, and then map the values to the new table.

 

 

 

Best Regards,

Stephen Tao

 

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

 

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @ngocnguyen ,

 

The result is this.

1.png

 

The method is to summarize all possible results of the Carrier, POL, and POD columns of the two tables into one table, and then map the values to the new table.

 

 

 

Best Regards,

Stephen Tao

 

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

 

Greg_Deckler
Super User
Super User

@ngocnguyen If I understand correctly, you would create a 2 separate tables using an Enter Data query where you would have POL and POD values and then you relate those tables to your other 2 tables. You could also create these tables using DAX or Power Query.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!