If clause logic creation

[Anonymous]

Hi All,

I have an use case where i have to create 2 calculated columns named to report and not to report.Below is the logic defined for those columns.

To report=

Case 1:if telecom/non telecom field is telecom and both the country A and country B is "GAZ"then i have to populate the total USD Value

Case 2: if telecom/non telecom field is telecom ,  country A  is "GAZ"and country B not "GAZ"then i have to populate the 50% of total USD Value

Case 3: if telecom/non telecom field is telecom ,  country A  is not  "GAZ"and country B = "GAZ"then i have to populate the 50% of total USD Value

Not to report=

Case 1: if telecom/non telecom field is telecom ,  country A  is "GAZ"and country B not "GAZ"then i have to populate the 50% of total USD Value

Case 2: if telecom/non telecom field is telecom ,  country A  is not  "GAZ"and country B = "GAZ"then i have to populate the 50% of total USD Value

Please find the sample data and output for reference

Can someone help me to arrive this logic.

Thanks in advance.

[v-robertq-msft]

Hi,

If you want to get help from DAX in the Power BI, please refer to the DAX forum of the Power BI community so that experts in DAX can help in advance.

https://community.powerbi.com/t5/DAX-Commands-and-Tips/bd-p/DAXCommands

Thank you very much!

Best Regards,

Community Support Team _Robert Qin