Today I face simple requirement, I need count on Gender, Entered data most of employee did not filed Gender in ERP system. So it is decided we show These records as male.For this I have to edit query and add custom column and update its value with If Condition.
For this I have to edit Query in power BIAdd Custom column with Employee Gender and similar logic.
= if [Gender]= "None" then "Male"
else [Gender]