Forum Discussion
Helper IITrouble comparing 2 columns from 2 tables.
I want to get the precentage off "Number", and the id as the total.
The id is in both tables. Both table 1 has the correct amount of id. And table2 has the correct amount of number opening.
When i set the id in value and number in the legend. It comes as 50/50.
mathician , for this you need to have a common ID Table. And then create a new measure and use that.
https://www.dropbox.com/s/op9lb78w9utdonz/Distinct%20from%20two%20Tables.pbix?dl=0
https://www.seerinteractive.com/blog/join-many-many-power-bi/
4 Replies
- amitchandak
Super User
mathician , The information you have provided is not making the problem clear to me. Can you please explain with an example.
In pie, you have option to show what all you want to show as data label
Appreciate your Kudos.
mathicianHere is an example of the solution(IMG). So on this donut, i have number as a precentage of the total of id.
Im trying to do the same thing, but on 2 columns from 2 different tables. Id is in table 1, and number is in table 2.
Example of the tables. Table 1
ID date 1 00000 2 00000 Table 2
ID Number 1 2 - amitchandak
mathician , for this you need to have a common ID Table. And then create a new measure and use that.
https://www.dropbox.com/s/op9lb78w9utdonz/Distinct%20from%20two%20Tables.pbix?dl=0
https://www.seerinteractive.com/blog/join-many-many-power-bi/