Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Creating impact calculator

Hi all,   I am new with Power BI and i am trying to re-create on tool i used in Excel. It basically tells me what is an impact of one person/process to the team result. Below is table and function ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi - Any luck in solving this? Trying to make the same sort of measure.

Thanks.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

 

Please see below.

Result and freq are measures I made.

Name is column in table.

 

Impact =
CALCULATE
([Result],ALLSELECTED(Table1[Name))
-
divide((CALCULATE([Result]*[Freq],ALLSELECTED(Table1[Name]))
    -
    CALCULATE([Result]*[Freq])),
        CALCULATE([Freq],ALLSELECTED(Table1[Name]))-[Freq])

 

Hope this helps

Filarap