Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

An impossibly simple division

Link to PBIX-file: ShopInfo   Hi all!   I could use some help wrapping my head around the following issue:   I have three tables in my model:     They look like:   Now I've cre...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    in depends on your use case scenario

    but in the most common case you can try a measure

    YearlySales per Employee = 
DIVIDE(
CALCULATE(MIN(Products[YearlySales])),
CALCULATE(MIN(ShopInfo[Employees]))
)
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

in depends on your use case scenario

but in the most common case you can try a measure

YearlySales per Employee = 
DIVIDE(
CALCULATE(MIN(Products[YearlySales])),
CALCULATE(MIN(ShopInfo[Employees]))
)