Forum Discussion

afrutos's avatar
afrutos
Icon for Resolver I rankResolver 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!
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

as an example for each measure try this

you need to iterate over month so that your total keeps the context of month.  Try this for each measure.

 

MINISTERIO =
CALCULATE (
    SUMX ( VALUES ( DATE[YEARMONTH] ), Consulta1[Importe] ),
    FILTER ( Consulta1, Consulta1[ORIGEN] = "MINISTERIO" )
)