Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 |
Solved! Go to 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.
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.
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
Hi,
Can anyone help with the below? Thank you.
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?
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
75 | |
56 | |
38 | |
33 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |