Forum Discussion

united2win's avatar
united2win
Icon for Helper III rankHelper 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
Icon for Solution Sage rankSolution Sage
4 years ago

Does this work?

 

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

  • united2win's avatar
    united2win
    Icon for Helper III rankHelper III
    4 years ago

    Still only returns on the German jurisdiction. I'm looking to see if a Seller has a DE jurisdiction and then extrapoloate that across the other jurisdictions. Like below: 

     

    SellerCountryCalculated DAX Column
    ADEYes
    AITYes
    BDEYes
    AFRYes
    CFR 
    • NickolajJessen's avatar
      NickolajJessen
      Icon for Solution Sage rankSolution 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
        Icon for Helper III rankHelper 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 😞