Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Media Movel em %

Bom dia! Tenho 2 colunas no Power BI em uma tabela que se chama Chamado. Uma que se chama "criado", que são datas e outra chamado "opçãodechamado". Na coluna opçãodechamado, ela pode me retorna 3 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Here is my sample data:

    This is the Calendar Table:

    The relationship:

    You can try to use this DAX to create a measure:

    total Qty. preventive OS / total Qty. OS = 
VAR _Total = COUNTROWS('Called')
VAR _PREVENTIVE = 
CALCULATE(
    COUNTROWS('Called'),
    'Called'[optioncalled] = "PREVENTIVE"
)
RETURN
DIVIDE(_PREVENTIVE, _Total)

    The final output is as below:


     

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Here is my sample data:

This is the Calendar Table:

The relationship:

You can try to use this DAX to create a measure:

total Qty. preventive OS / total Qty. OS = 
VAR _Total = COUNTROWS('Called')
VAR _PREVENTIVE = 
CALCULATE(
    COUNTROWS('Called'),
    'Called'[optioncalled] = "PREVENTIVE"
)
RETURN
DIVIDE(_PREVENTIVE, _Total)

The final output is as below:


 

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.