How to add values from two similar columns (from two tables) into a new measure or column?

[Anonymous]

I have two tables; 1) Completed and 2) Cancelled or Deleted. Both tables have a column called WKFL_ID. I need to add the workflow id's from each table together to get a Total (total = completed + cancelled/deleted). I have a created a 1:1 relationship between the two tables on WKFL_ID columns. I don't know if this step was necessary or not.

To be a bit more specific, what I am looking for is the COUNT of WKFL_IDs from table 1 to be added to the COUNT of WKFL_IDs from table 2 = Total Count or SUM of the Counts (the new count of total). It should probably be the distinct counts from each table.

Please let me know if there is a DAX solution to this problem, or if you need more information. I am not able to post any files due to corporate firewall. 

Thanks!

[Anonymous]

Hi @Anonymous ,

May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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

[Ashish_Mathur]

Hi,

Create a thid table with all unique ID's.  Create a relationship (Many to One and Single) from the ID column of each of the 2 tables to this third table.  To your visual/slicer/filter, drag ID from the new table.  Create these measures

Measure 1 = countrows(Completed)

Measure 2 = countrows(Cancelled)

Measure 3 = [Measure 1]+[Measure 2]

Hope this helps.