Forum Discussion

cyborgandy's avatar
cyborgandy
Helper II
3 years ago

DAX Assistance Required

I have created a calculated column in my dataset where it gives me yes or no, however when I writing a different dax to obtain a different count and writing IF (Trying to use the calculated column however its not coming with the IF statement).

e.g Calculated column Name is Within Country and its genetrating yes and no in the rows,

Now wanted to write a DAX for : IF Within Country ="Yes", Calculate(Amount Of Spend), "0" however not able to get within country with IF statement.

Could someone help with the DAX

 

 

Need Help

1 Reply

  • pratyashasamal's avatar
    pratyashasamal
    Memorable Member
    3 years ago

    Hi cyborgandy ,
    You can simple use any aggregation with Country Column as it is text type.
    For example:-

    Measure  = IF(MIN(Table[Country])="Yes" , SUM(Table[user_amount]),0)
    Thanks,
    Pratyasha Samal
    Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
    If you found this post helpful, please give Kudos C