The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi All,
Anyone can help me to calculate this formula? I want to get cumulative value (in %) using below dataset.
Ex: (40/59) * 100
40 refer to ticket id which is FR_Hour < 5
59 refer to total ticket
Thanks
Solved! Go to Solution.
Hi @twister
Try something like this.
Measure =
DIVIDE(
CALCULATE(
COUNTROWS( 'Table' ),
'Table'[FR_Hour] < 5 ),
COUNTROWS( 'Table' )
) * 100
Hi @twister
Try something like this.
Measure =
DIVIDE(
CALCULATE(
COUNTROWS( 'Table' ),
'Table'[FR_Hour] < 5 ),
COUNTROWS( 'Table' )
) * 100
nice..its work perfectly..thanks
User | Count |
---|---|
28 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
34 | |
13 | |
12 | |
9 | |
7 |