Forum Discussion

Akvatraine02's avatar
Akvatraine02
New Member
5 years ago
Solved

Ayuda con DAX

Hola a todos, tengo una duda que no he podido resolver y quería ver si me podrían orientar: Pasa que quiero hacer una columna, medida o parametro, donde yo pueda tener el promedio diario de horas en...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Akvatraine02 

     

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

     

    You may create a measure as below.

    Result = 
DIVIDE(
    CALCULATE(
        SUM('Table'[Loss hours]),
        ALLSELECTED('Table')
    ),
    DISTINCTCOUNT('Table'[YearMonth])*30
)

     

    Result:

     

    Best Regards

    Allan

     

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

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Akvatraine02 

 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

 

You may create a measure as below.

Result = 
DIVIDE(
    CALCULATE(
        SUM('Table'[Loss hours]),
        ALLSELECTED('Table')
    ),
    DISTINCTCOUNT('Table'[YearMonth])*30
)

 

Result:

 

Best Regards

Allan

 

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