Forum Discussion

stuartm's avatar
stuartm
New Member
8 years ago
Solved

Percentages

Hi,

 

I've been searching through the other examples but nothing is exactly like my example so I'm posting here.

 

This is my dataset:

 

I'm trying to create a cross-tab of date by absence rate : ('Hours Lost'/'Total Time Available'). Drill-able on absence unit.

 

 

Q's

 

1. Is this possible?

2. If so how can this be done?

 

Thanks

 

 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi stuartm,

     

    #1, Yes, it is possible.

     

    #2, You can try to use below formula if it suitable for your scenario.

    Measure =
CALCULATE (
    SUM ( Table[Hours Lost] ) / SUM ( Table[Total time Available] ),
    VALUES ( Table[Date] ),
    VALUES ( Table[Category Column] )
)

    Notice: Please use your category column to replace bold part.

     

    Regards,

    Xiaoxin Sheng

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi stuartm,

     

    #1, Yes, it is possible.

     

    #2, You can try to use below formula if it suitable for your scenario.

    Measure =
CALCULATE (
    SUM ( Table[Hours Lost] ) / SUM ( Table[Total time Available] ),
    VALUES ( Table[Date] ),
    VALUES ( Table[Category Column] )
)

    Notice: Please use your category column to replace bold part.

     

    Regards,

    Xiaoxin Sheng