Forum Discussion
Solved
Join not working
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
Hi marami21 ,
Set all the columns "don't Summarize" in the visual as below.
For more details, please check the pbix as attached.
2 Replies
In Visualization pane, you can see all your measures in values. Right-click or click on the arrow and use DO not summarize.
Hi marami21 ,
Set all the columns "don't Summarize" in the visual as below.
For more details, please check the pbix as attached.
