Join not working

[marami21]

Hey,

I have two tables

variance	price	category	date	id
3%	9.99	Shirt	11022019	Shirt11022019
4.5%	12.99	Shirt	11022019	Shirt11022019
2.5%	99.99	Shoes	3022019	Shoes3022019
3%	59.99	shoes	3022019	3022019

total var	price	category	date	id
3.75%	11.49	Shirt	11022019	Shirt11022019
2.86%	79.99	shoes	3022019	shoes3022019

Using the id column to be able to perform joins, what I want is, for example graph the variance, price, and total var, total price of each item. However when I graph the total var it automatically show the count of total var instead of the value

How can I fix that,

Thank you in advanced

[v-frfei-msft · Accepted solution]

Hi @marami21 ,

Set all the columns "don't Summarize" in the visual as below.

For more details, please check the pbix as attached.

[amitchandak]

In Visualization pane, you can see all your measures in values. Right-click or click on the arrow and use DO not summarize.