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.
Solved! Go to Solution.
@united2win You can try this Measure:
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:
|Seller||Country||Calculated DAX Column|
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 😞
Yes, neat trick is to just wrap the measure in a calculate
nb. countrows being the measure we created above.
Also it would have been better to know, that a calculated column was needed, when i asked in message 2. 😅
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
Still only returning German addresses unfortunatley. Sorry, I thought I already mentioned that, thanks for your help on this...Very muc appreciated.
Also copied the measure.
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?
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 ()
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.