Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Cannot put measure correctly as a percentage

Dear,

I have an issue which i need help with.

I have the following visual which shows the new incoming orders during the working hours. 

Works great and is a result of a massive DAX formula

 

Vosjeee7502_0-1687531254640.png

 

Now i would like to have it show in percentage of the total but when i do that it give the following:

Vosjeee7502_1-1687531368200.png

 

So thats no where near the 100%, hopefully you can assist. 

I'll drop a screenshot of the dataset and the formula. 

 

Nieuwe lijnen picking =
var _cur =
SUM(Plakken[Lijnen Gedaan Picking])+SUM(Plakken[Lijnen Openstaand Picking]) //current time's value
var _prevTime = CALCULATE(MAX(Plakken[Meting Van]),ALL(Plakken[Meting Van]),'Plakken'[Meting Van]<MAX(Plakken[Meting Van])) //previous time
var _prev = CALCULATE(SUM(Plakken[Lijnen Gedaan Picking]),ALL(Plakken[Meting Van]),'Plakken'[Meting Van]=_prevTime) + CALCULATE(SUM('Plakken'[Lijnen Openstaand Picking]),ALL(Plakken[Meting Van]),'Plakken'[Meting Van]=_prevTime) //previous time's values
return
_cur-_prev
 
 
Vosjeee7502_2-1687531491654.png

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.