Forum Discussion

LuisMLRossa's avatar
LuisMLRossa
Frequent Visitor
4 years ago
Solved

Matrix Visual :: "Ghost" numbers not adding up

Hi All,   Kindly request your help about this issue.   In short: Some numbers in a matrix visual are invisible to totals, sub-totals, etc.   In detail: I have a matrix visual and in the rows ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    LuisMLRossa , Try a measure like

     

    Sumx(summarize(Table, Table[Level1], Table[Level2], "_1",Result),[_1])

amitchandak's avatar
amitchandak
Super User
4 years ago

LuisMLRossa , Try a measure like

 

Sumx(summarize(Table, Table[Level1], Table[Level2], "_1",Result),[_1])

LuisMLRossa's avatar
LuisMLRossa
Frequent Visitor
4 years ago

Hi amitchandak,

 

Good morning to you.

 

I tried what you suggested and .... now I have the results I needed.

 

Thank you.

 

More Detail:

 

The dax formula I made was:

NewAmount3 = sumx(SUMMARIZE(Sales,Sales[Level1],Sales[Level2],Sales[Amount]),[NewAmount])
 
But I tried with another mesaure and it worked:
NewAmount2 = sumx(values(Sales[Level2]),[NewAmount])
 
I think the base concept is the same.