Join/Merge two table and assign new value to category

[SEPA]

Dear all,

i have an situvation were i need to join two tables and calculate value based on codition and fill the new value to another category.

if you see the first table, i have kep 0 for the category "Sales Online" which i need do the sum of all lead_number count and do the sutraction where source key =10

any idea.... i have tried Switch but didnt help me..

Thanks

[Anonymous]

Hi @SEPA,

I think you can take a look at the following blog to create a formula based on calculated group if help with your scenario:

Matrix In Power BI Using Calculation Groups - Enterprise DNA

Regards,

Xiaoxin Sheng

[SEPA]

Actually, the right table is my dimension table and the left table coming from fact table.. i need to do the subtraction the lead count where source key=10 and get that value and assign to Sales online category