Forum Discussion

SSS's avatar
SSS
Helper I
8 years ago
Solved

Compare between measures

Good Morning fellas,   My problem is the following one:   I am representing a measure in a line graph that calculates my Rotation Index.   My data looks like: FECHA(is the date)         Countr...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi SSS,

     

    You only need to add a little part to your formula like this. Which measure do you use in your visual? You can do it to all your measures.

     

    Medida Dia Indice Rotacion =
CALCULATE (
    SUM ( Consulta1[Pendiente Valor] ) / [Medida DiaProduccionMediaDiaria],
    ALL ( Consulta1[Territory] )  //clear the filter from Consulta1[Territory]
    )

    The function has the similar behavior: Allexcept. If you need more help, please provide a sample? The pbix file would be great.

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi SSS,

 

You only need to add a little part to your formula like this. Which measure do you use in your visual? You can do it to all your measures.

 

Medida Dia Indice Rotacion =
CALCULATE (
    SUM ( Consulta1[Pendiente Valor] ) / [Medida DiaProduccionMediaDiaria],
    ALL ( Consulta1[Territory] )  //clear the filter from Consulta1[Territory]
)

The function has the similar behavior: Allexcept. If you need more help, please provide a sample? The pbix file would be great.

 

Best Regards!

Dale