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 feel like this post was also here yesterday..

Specify what you already tried. Specify what suggestions were made yesterday that didn't work.

Are you looking to do it in a measure or a calculated column? Do you have acces to edit the data in power Query?

united2win's avatar
united2win
Helper III
4 years ago

Hi,

Below was already tried, and like mentioned on the other post, it's only returning "Yes" for the German jurisdictions. I'm trying to create a calculated column and yes I have access to power query. 

Has German Adress = 
VAR vSellerCurrentRow = SellerTable[Seller]
RETURN
    IF (
        CALCULATE (
            COUNTROWS ( SellerTable ),
            SellerTable[Seller] = vSellerCurrentRow,
            SellerTable[Country] = "Germany"
        ) > 0,
        "Yes",
        BLANK ()