Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Calculation in a Column - with/without slicer

Hello,   I've seen  lots of similar new messages lately but couldn't find a solution to my problem.   Im gonna share three screenshots about the issue.   PB1 screenshot - column "% gerceklesen"...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    HI Anonymous,

     

    Create a measure that calculates both value and not a colum as you can see below it works fine:

     

    Measure % Ger = DIVIDE(SUM(Sats[Total TEU Gerçekleçen]),SUM(Sats[Total TEU Hedeflenen]))

     

     

    Regars,

    MFelix

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

HI Anonymous,

 

Create a measure that calculates both value and not a colum as you can see below it works fine:

 

Measure % Ger = DIVIDE(SUM(Sats[Total TEU Gerçekleçen]),SUM(Sats[Total TEU Hedeflenen]))

 

 

Regars,

MFelix

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago
    Thanks a lot! It worked like magic. As a beginner level power BI user, that was exciting to use measure :)