Forum Discussion
Create a custom Table
Anonymous try this DAX formula, I blindly followed what you explained.
Result = VAR __table = SUMMARIZE( SetB, SetB[Product], SetB[Region], "Sales", SUM( SetB[Sales] ) ) RETURN UNION( INTERSECT( SetA, SUMMARIZE( FILTER( __table, [Sales]= 0 ), [Product], [Region] )), EXCEPT( SUMMARIZE( FILTER( __table, [Sales]= 0 ), [Product], [Region] ), SetA ) )
here is the output of result table
Hi,
Let me explain in detail about the requirement.
I have 2 datasets A & B A is primary Set9 Unique Values and B is a Normal data. I need to find the odd values from B by comparing the values with SetA.
Exap:
1.The Result is to get the Region with Zero sales and the region should be in SETA.
Exaple, Product A with Sales 0 In Florida should be excluded. only Products with Region exists in SET A should apprear.
Only Zero sales Region with product should be tracked.
Please check the clienk for your reference.
https://drive.google.com/file/d/1JhAEHlYQGAJUaJ7v3KrSZbLFLt6lC3Yx/view?usp=sharing
Please let me know if you need further details,
REgards,
Regards.
That's a completely different requirement altogether.
Look at your first two posts, you also provided a sample dataset in your second post and none of those two posts had any clue about this requirement at all.
What's the point in not adding that detail in your original post at the first place?
Sorry, wish to try from this, but dint find any clue on this.
Appreciate your Hep help.
Anonymous try this DAX formula, I blindly followed what you explained.
Result = VAR __table = SUMMARIZE( SetB, SetB[Product], SetB[Region], "Sales", SUM( SetB[Sales] ) ) RETURN UNION( INTERSECT( SetA, SUMMARIZE( FILTER( __table, [Sales]= 0 ), [Product], [Region] )), EXCEPT( SUMMARIZE( FILTER( __table, [Sales]= 0 ), [Product], [Region] ), SetA ) )
here is the output of result table