We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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 |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |