Forum Discussion
Division based on 2 other values from different columns
Hi everyone, I am very new to DAX and the purpose of using Pbi is to model data for our manufacturing production control. I have collected data for the below: -Time study data ( Machine, Mater...
My apologies, I used the wrong data anyway.
Please see the following Dax:
It should be returning 67.5%, but it is returning 77.1%
Completed ticket data:
Timestudydata:
tamerj1
Community Champion
Community Championnicklabh
In your visual you should be using the [Material #] from the TimeStudyRawDat table (the dimension table). Then apply the following measure.
Note: Please do not use LOOKUPVALUE, as it is an inefficient FUNCTION and proves useless in many scenarios.
Production Efficiency =
AVERAGEX (
TimeStudyRawDat,
DIVIDE (
AVERAGE ( 'Completed Ticket Data'[Pieces/Hr] ),
TimeStudyRawDat[Prices/HR]
)
)