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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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))
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 27 |
| User | Count |
|---|---|
| 124 | |
| 88 | |
| 73 | |
| 66 | |
| 65 |