Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

Matrix

hello good morning, I am managing a matrix that gives me some amounts per month and per cinema name, however the totals are not being taken correctly, I don't know what is the reason for this. Does...
Need Help
  • afrutos's avatar
    afrutos
    4 years ago

    In the end I managed to solve it on my own:
    To correctly apply the segmenter I had to create myself a measure for each column, and at an origin I was not correctly applying sumx at the totals level,
    The final measure was like this:

    MINISTERIO FILTRO = var estado=SELECTEDVALUE(SEGMENTADOR[Columna2])
     
    return
    SWITCH(true(),
     
    estado=1, SUMX(VALUES(Consulta1[IdEmpresa]), if([DIFERENCIA M-E]<0,[MINISTERIO],BLANK())),
    estado=2,SUMX(VALUES(Consulta1[IdEmpresa]), if([DIFERENCIA M-E]>0,[MINISTERIO],BLANK())),
    estado=3, SUMX(VALUES(Consulta1[IdEmpresa]), if([DIFERENCIA M-E]=0,[MINISTERIO],BLANK())), [MINISTERIO])
     
    Thanks anyway!
afrutos's avatar
afrutos
Resolver I
4 years ago

In the end I managed to solve it on my own:
To correctly apply the segmenter I had to create myself a measure for each column, and at an origin I was not correctly applying sumx at the totals level,
The final measure was like this:

MINISTERIO FILTRO = var estado=SELECTEDVALUE(SEGMENTADOR[Columna2])
 
return
SWITCH(true(),
 
estado=1, SUMX(VALUES(Consulta1[IdEmpresa]), if([DIFERENCIA M-E]<0,[MINISTERIO],BLANK())),
estado=2,SUMX(VALUES(Consulta1[IdEmpresa]), if([DIFERENCIA M-E]>0,[MINISTERIO],BLANK())),
estado=3, SUMX(VALUES(Consulta1[IdEmpresa]), if([DIFERENCIA M-E]=0,[MINISTERIO],BLANK())), [MINISTERIO])
 
Thanks anyway!
vanessafvg's avatar
vanessafvg
Community Champion
4 years ago

well done sorry had a few busy days.