Forum Discussion

united2win's avatar
united2win
Helper III
4 years ago
Solved

Countrows DAX help

Hi, I have the following table, looking to create a column with a DAX formula that identies if a Seller has a German Registration. Can anoyne provide that formula pls? I was hoping it would be simpl...
Need Help
Tips and Tricks
  • NickolajJessen's avatar
    NickolajJessen
    4 years ago

    I just added the country as so:

    Please mark this answer as the solution if it resolves your issue.
    Appreciate your kudos! ☺

     

NickolajJessen's avatar
NickolajJessen
Solution Sage
4 years ago

I just added the country as so:

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! ☺

 

united2win's avatar
united2win
Helper III
4 years ago

This is exactly what I'm looking for, did you create this as a measure or new column? I've copied the DAX into a new column, but still getting "Yes" only for Germany 😞

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    A measure 😊

    • united2win's avatar
      united2win
      Helper III
      4 years ago

      And would it be possible to get the same as a calculated column?

      • NickolajJessen's avatar
        NickolajJessen
        Solution Sage
        4 years ago

        Yes, neat trick is to just wrap the measure in a calculate 

        nb. countrows being the measure we created above.

        Also it would have been better to know, that a calculated column was needed, when i asked in message 2. 😅

        Please mark this answer as the solution if it resolves your issue.
        Appreciate your kudos! 😊