Forum Discussion

mueland's avatar
mueland
Frequent Visitor
7 years ago
Solved

Bi-directional filter, SUM issue

Hi,   Trying to understand the filtering in my report. I have two tables where  Table A is my fact table and Table B is dimensions with attributes for WO.No. There are some issues with the quality ...
Need Help
  • mueland's avatar
    mueland
    7 years ago

    Hi!

     

    Thanks for your follow-up and sorry for my late reply. Was not an issue with the sum but in addition to having blank fields my table B was also missing values, so when filtering om blank I was also missing out some orders. Thanks for the follow-up either way! :)

     

     

v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity Support
7 years ago

  

Hi mueland ,

 

You can create measure like DAX below.

 

Earned total = CALCULATE(SUM(TableA[Earned]))

 

Or you needn't to create anything, just change the show aggregation.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.