Forum Discussion

united2win's avatar
united2win
Helper III
4 years ago
Solved

Help with DAX?

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. 

 

SellerCountryDAX Column
Seller AGermanyYes
Seller BItaly 
Seller AFranceYes
Seller AItalyYes
Seller CGermanyYes
Need Help
Show and Tell

6 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    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's avatar
      united2win
      Helper III
      4 years ago

      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's avatar
      united2win
      Helper III
      4 years ago

      Hi, 

       

      Can anyone help with the below? Thank you.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.