Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Please give me measure for below requirement
I have a column as
Delievry
On Time
Late
On Time
Not Available
On Time
On Time
Late
And the result I need is
Total there are 7 rows or values, On Time = 4/7 * 100=57.14%
Please help me
Solved! Go to Solution.
Hi @mahra-in
Try this MEASURE
=Divide(Calculate(COUNTROWS(TableName), TableName[Delievry]="On Time"), COUNTROWS(TableName))
Hi @mahra-in
Try this MEASURE
=Divide(Calculate(COUNTROWS(TableName), TableName[Delievry]="On Time"), COUNTROWS(TableName))
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.