How to add a calculate column with an if condition

[Anonymous]

Hi

Am trying to add a calculated column in which the results refer to two different columns. So in the below table, I want to add the column "Exotic" and i want the count of exotic fruits and vegetables

Type	Sub Category	Exotic
Fruit	Exotic	1
Fruit	Non Exotic
Vegetable	Exotic	1
Fruit	Exotic	1
Vegetable	Non Exotic

[parry2k]

@Anonymous not sure your logic is clear, according to data, should be two exotic fruits, but regardless you can try adding the following column, assuming you want 1 for each exotic row

Exotic = IF ( Table[Sub Category] = "Exotic", 1 )

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

[Anonymous]

That helps! Great and thanks. Also, i want to another column too in which i want all Fruits and Vegetables that are not exotic. Now the problem with the data is under Type column there are more than fruits and vegetables and in category column i have blanks and others too. So basically, i want to count "Fruit" & "Vegetable" where Category Column is not equal to "Exotic".

[amitchandak]

@Anonymous , You can try like

if([Type] in {"Fruit","Vegetable"} && [Sub Category] <> "Exotic" )

But please follow what @parry2k  has suggested for the post.

[parry2k]

@Anonymous Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

It is very hard to answer if you are going to share information in bits n pieces.

[Anonymous]

Ok Thanks. Am a beginner and still learning so i hope someone else can answer my question.

[parry2k]

@Anonymous we all are learning here, you should read the post which I shared previously and repost your question.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[Anonymous]

ok sure

[dax]

Hi @Anonymous ,

I am not clear about your requirement, if possible could you please inform me more detailed information(such as your expected output and your sample data )? Then I will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.
Best Regards,
Zoe Zhi

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