Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Using slicer in summarised table

I have below DAX:   SUMMARIZE(Filter(Table ,Table[type trans]="Invoice") , Table[As of Date] , Table[account_cd] , "DBE", if([Measure 01]>0,[Measure 01],blank()), "CRE", if([Measure 01]<0,[Measu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Account code cannot be used in table since we require table in summarised format.

 

Measure 01 has positive and negative values , positive ones has to be grouped under debit and negative under credit based on As of date and account cd.

Measure 01 has following DAX = Sum(Table[Amount]) , and when we select a particular type trans only amounts pertaining to that should be used.

 

 

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , if your formula is correct then just remove that from the filter and add to the slicer. As long as tables are connected it should filter