Compare two columns form different Table

[Anonymous]

Hi ,
I have two different tables table1 has category and table 2 has category and sub category In Power BI, I want the result to be shown in as
1.compare sales and qty column as category and subCategory in one column (i.e. in output image I have created 2 different column chart I want it as one )how can I get it by DAX
2.category name should come first(from left) on axis
sharing some images for better understanding

 

 

[Anonymous]

Hi @Anonymous ，

 I did a test using similar data to yours, and I wonder if this is what you are trying to achieve?

Compare their respective sales and QTY with category  and sub-category as X-axis?

Best regards,

Community Support Team Selina zhu

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

[Daryl-Lynch-Bzy]

HIi @Anonymous , I am wondering why you need to the two tables in the data model.  The Sub-Category contains all the data need to create the two visuals you have shown.  If you are trying to add a reconciliation between the two tables, I would recommend using Power Query to compare the two tables.  If there is an issue, then report this exception in Power BI.

If you want to compare using DAX, you will need to create Bridging Tables for Date and Category.  These tables can then be joined to both tables.  When they are joined, these table will apply filters to both tables.  You will be able to compare the Sum of table 1 to Sum of table 2, and calculate a difference.  Please watch the following GuyInACube video to understand this:  Handling MULTIPLE fact tables in Power BI - YouTube