Forum Discussion

christianfcbmx's avatar
christianfcbmx
Post Patron
8 years ago
Solved

Matrix Visual doesnt calculate right without a filter...why?????

Dear Colleagues!!! How can I make the matrix visual calculate right without a filter?

 

I have a matrix and I´m using 2 filters (Slicer with dates and Chiclet slicer with weeks) If I chose a range of time including 4 weeks the matrix table show incorrect values and when I click on the weeks (2 cond slicer) I get correct Values...Can somebody tell me why please!!!

 

Incorrect ValuesCorrect Values....

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • christianfcbmx's avatar
    christianfcbmx
    8 years ago

    Solved!!! I dont know what exactly happen but I realized that my DAX dont work if there are "blanks" in between,  meaning that blanks interfiere some how in the formula calculation (I dont know what happen exactly in there)... In this case I used the visual level filter and let blanks out of this operation and the problem is gone!

     

     

    Thanks to my self XD

1 Reply

  • christianfcbmx's avatar
    christianfcbmx
    Post Patron
    8 years ago

    Solved!!! I dont know what exactly happen but I realized that my DAX dont work if there are "blanks" in between,  meaning that blanks interfiere some how in the formula calculation (I dont know what happen exactly in there)... In this case I used the visual level filter and let blanks out of this operation and the problem is gone!

     

     

    Thanks to my self XD