Forum Discussion

Sachin_Tandon's avatar
Sachin_Tandon
Frequent Visitor
8 years ago
Solved

Measure not displaying correct value in Total Row

Hi,   I'm truly stumped with this one.   I am trying to show the sales for different products, and brands, for different months. I have created measures, as I also want to be able to show the sal...
Need Help
  • Sachin_Tandon's avatar
    Sachin_Tandon
    8 years ago

    I tried creating a separate dimension table for Status, but now get completely bogus behaviour!

     

    See attached:

     

    PBIX file 2

     

  • TomMartens's avatar
    TomMartens
    8 years ago

    Perfect!

     

    Please mark the most appropriate post as an answer, this will help others! And you might also consider to give that post a kudo, if it saved you headache and time ;-)

     

    Cheers,
    Tom

Sachin_Tandon's avatar
Sachin_Tandon
Frequent Visitor
8 years ago

Hi Tom,

 

Here is the raw data file...

 

XLS file

 

I've spent hours trying to solve this, but am just getting stumped...it must be a common problem for so many users!

Tried ALLSELECTED to ignore internal filters and keep external filters, but nothing seems to work... : (

 

Hopefully, the DAX Experts around can help me crack it!

Sachin_Tandon's avatar
Sachin_Tandon
Frequent Visitor
8 years ago

I've set bi-directional filtering on between the Status Table and Main Sales Table which seems to help, but still trouble with the totals not adding up the rows beneath, when the status slicer is used

 

Sachin