DAX syntax

[vkandala]

Please, I need some help.

Thanks

[vkandala · Accepted solution]

Hi 

I 've tried using 

 = IF(OR(OR(OR(OR(OR(OR(OR(OR('Car Data'[car]= "BMW",'Car Data'[car]= "Audi"),'Car Data'[car]= "Jaguar"),'Car Data'[car]= "Mercedes-Benz"),'Car Data'[car]= "Bentley" ),'Car Data'[car]= "Aston Martin"),'Car Data'[car]= "Rolls-Royce"),'Car Data'[car]= "Lamborghini"),'Car Data'[car]= "Ferrari,"),"Luxury","General")

and this worked!!

Thanks all for your workaround.

[v-shex-msft]

Hi @vkandala,

Based on your screenshots, you can refer to below formula to check the segment of car column.

Calculated column: if count of current brand which exist in table is greater than 5, it is a general brand, otherwise it is a luxury brand.

Result = IF(COUNTAX(FILTER(ALL(Table),[Car]=EARLIER(Table[Car])),[Car])>5,"General","Luxury")

Notice: you can modify the bold number to switch the rare condition.

Regards,

Xiaoxin Sheng

[dilumd]

You can use "IF" and "OR" function to achieve the same result. Give me some sample date to help you with this?

[vkandala]

Thanks, Dilmund for the reply.

I know we can do in the query editor. but can we achieve the same using a DAX syntax in the data view itself?

Thanks.

[dilumd]

Use a conditional column.