Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.