Divide all columns by result of one column


#1

Hello,

I am calculating manufacturing time of all part numbers. In that I want to assume one part number as master and divide all other part number by the master part number time.
How to do this in Power BI
I have attached the model along with this.
When I calculate the manufacturing time of master part number using calculate & filter - I am getting the correct result in card
But when I place this in the table - It is showing no result where the row has other part numbers
Can you help.

EquivalentUnits.pbix (1.2 MB)


#2

Can you please expand on your question with all details inside the forum post. This means images, DAX formulas, model etc.

Thanks