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 absenc...
  • 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

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

stuartm's avatar
stuartm
New Member
8 years ago

xie xie nin. wo shi yi shi.