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]))
)
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi Anonymous ,

 

You need to change the direction of relationship to both between Shops and ShopInfo.

 

Also create this measure:

 

Measure = DIVIDE(SUM(Products[YearlySales]); SUM(ShopInfo[Employees]))
 
 
Ricardo