Forum Discussion
Help with DAX?
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.