Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure that sums a calculation for each type

Hi everyone,   I am hoping you can help. As shown in the attached .pbix, I am trying to create a measure that does a calculation for each type of unit.   https://www.dropbox.com/transfer/AAAAAI7Q...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    try this

     

    Opportunity Try 1 = SUMX(VALUES('Sample'[Type]),[Geometric Mean Actual]-[Geometric Mean Target])

     

    Regards,

    Marcus

    Dortmund - Germany
    If I answered your question, please mark my post as solution, this will also help others.
    Please give Kudos for support.

     

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi Anonymous ,

 

try this

 

Opportunity Try 1 = SUMX(VALUES('Sample'[Type]),[Geometric Mean Actual]-[Geometric Mean Target])

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you!