Forum Discussion
Compare 2 tables
Hi
I have 2 tables from 2 different sources, and the turnover I would like to compare per person. In itself no problem. I created the formulas with DAX. Only now I want to add a slicer to the results table, so that you can filter only on the differences. You can possibly do this through the filter panel, but can this also be done very simply through a slicer? I know you can make an extra table, but can it be easier?
Thanks!
3 Replies
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi, Moniek
You can try the following methods.
New table:
Table = DISTINCT(UNION(VALUES(Table1[Person]),VALUES(Table2[Person])))Measure:
Source1 = CALCULATE(SUM(Table1[Turnover]),FILTER(ALL(Table1),[Person]=SELECTEDVALUE('Table'[Person])))+0Source2 = CALCULATE(SUM(Table2[Turnover]),FILTER(ALL(Table2),[Person]=SELECTEDVALUE('Table'[Person])))+0Difference = [Source1]-[Source2]Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
