Need help to solve Dax messure

[Anonymous]

Hello All,

I need  help to get solve a dax messure.

I have a column in my table as OFS/ONS which contain values as OFS and ONS.

and i have project id's in my table.

I am trying to filter the table using Project id.

now i am trying to show the project type as if the project is of type OFS and ONS or only ONS then show it as INTERNATIONAL,

If it is only OFS then show as NATIONAL,

I have tried the below calculated column but i am not getting the output as i need.

Can anyone suggest me how can i solve this.

Thanks in advance.

Mohan V

[GilbertQ · Accepted solution]

Hi @Anonymous

What I would suggest doing is rather than trying to create the calculated column using DAX rather do it in the Query Editor and create a Custom Column.

You could then create it in your table 'Allocation Report' with the following code

if [Onsite/OffShore] = "ONS" and [Onsite/OffShore] = "OFS" then "International"
else if [Onsite/OffShore] = "OFS" and [Onsite/OffShore] <> "ONS" then "National"
else "Other"

[SivaMani]

Hi @Anonymous,

It would be helpful if you share the sample data.