Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
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
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
xie xie nin. wo shi yi shi.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |