No totals in a column

[jlarques]

Hi Team,

I have a matrix that doesn't show some totals in some columns, as you can see in the image attached.

I want the right Totals from rows and columns and global totals by rows and columns. These options are activated on the matrix, but it doesn't work. 

Any suggestions?

Thanks to everyone for your help.

José Luis

[aliozturkmen]

Super easy example. If you use a Matrix for the table below. and use MIN formula ; John will show 2, Mark will be 2, Joe will e 0 and your Total will be 0 again. 

[jlarques · Accepted solution]

Hi @aliozturkmen  and @jaideepnema ,

you were right about MIN and MAX. I was using the first image to create my time intelligence and when I changed MIN and MAX by FIRSTDATE and LASTDATE, the totals work as you can see in the image below.

As always, thanks everyone from this amazing community, specially to @aliozturkmen  and @jaideepnema .

José Luis 

[jlarques]

Understand. So, what's the solution to get the right total? Don't I have to use the MIN or MAX function?

Thanks,

[aliozturkmen]

@jlarques 

You might have a measure on your values as FIRST or MIN etc. In the case of that; MIN Total for the column might be zero and your total will be zero for the Total Row

[jlarques]

Hi @aliozturkmen,

in this project, I'm using these measures with MIN and MAX to create my calendar:

VAR MinYear = YEAR ( MIN ( INTERLOCUTORS[DATA_ALTA]) )

VAR MaxYear = YEAR ( MAX ( INTERLOCUTORS[DATA_ALTA]) )

Does this have something to do with it?

Thanks,

[aliozturkmen]

It's hard to say without seeing where you are using the Measure and the table structure but like I said the TOTAL row in Pivots won't sum up your values in the table directly if you use DAX on your value field. It will use the DAX measure on your total set of data.

[jlarques]

What do you mean exactly? Could you give me an example, please?

[jaideepnema]

@jlarques  Not clear.....Can you share a pbix with sample data ?

[jlarques]

Hi @jain,

it's a confidential customer. What kind of info do you need? I want results like the image attached.

Thanks,