Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Create a custom Table

Hello All,   Please me with a DAx to create a new Table with an existing DATASET with Filter. I need to carete a New table With columns Products and Amounts with Blanks. Result      ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Sorry, wish to try from this, but dint find any clue on this. 

 

Appreciate your Hep help.

parry2k's avatar
parry2k
Super User
7 years ago

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