Help with DAX?

[united2win]

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 simple, but having difficulty. 

Seller	Country	DAX Column
Seller A	Germany	Yes
Seller B	Italy
Seller A	France	Yes
Seller A	Italy	Yes
Seller C	Germany	Yes

[Anonymous · Accepted solution]

Hi @united2win ,

According to this——For example if a Seller has both Italy and Germany, the Italian address is blank. How do I change the formula to include yes for both lines?

So for seller A , it has three countries,  including Germany, so the three lines for seller A are all "Yes".

I think @selimovd 's method works fine, it acheive the same output as your expected.

Below is my workaround and output.

Column = 
var _t= SUMMARIZE(FILTER('Table',[Seller]=EARLIER('Table'[Seller])),[Country])
return IF("Germany" in _t,"Yes")

If I'm misunderstanding, please share more details to help us clarify your scenario.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[selimovd]

Hey @united2win ,

you can add a new calculated column and check if the seller in the current row has another row with country Germany.

The following measure should do that:

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

The result looks then like that:

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[united2win]

Hi, 

Can anyone help with the below? Thank you.

[united2win]

Thanks Dennis, I've inputted the formula, but it's only returning "Yes" for the German addresses. For example if a Seller has both Italy and Germany, the Italian address is blank. How do I change the formula to include yes for both lines?

[united2win]

[selimovd]

Hey @united2win ,

when you reply, please make sure to mark the person with the the @ symbol like this: @united2win .

Otherwise I will not be notified that you replied and then I cannot help you.

If you want to check if the Seller has an Italian or German address, then try that one:

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

Otherwise you have to be a little bit more specific with your requirements. My solution was doing exactly what you asked for.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic