Forum Discussion

NomisSimon's avatar
NomisSimon
Regular Visitor
3 years ago

Revenue calculation over different projects

Hey, I am working on a project dashboard. Therefore i have 7 Projects in my Database (Projectnumber) and I would like to have an intereacitve revenue -depending on my overall filter:   Project...
Need Help
Adescrit's avatar
Adescrit
Impactful Individual
3 years ago

Hi NomisSimon 

You can try the following:
SUMX( TableName, TableName[Revenue by Day] * TableName[Revenue Multiple per Day] * 360 )

Just replace TableName with the name of your data table contianing the project number and revenue columns.

  • NomisSimon's avatar
    NomisSimon
    Regular Visitor
    3 years ago

    Hey Adescript, 

     

    thank you very muche, with your quick respond. 

    I tried it already - i get an value but - the value is not changing if i am changing my project - your formula seems to add up all revenues together - but i need them separate depending on my filter. 

     

    Thank you

     

    • Adescrit's avatar
      Adescrit
      Impactful Individual
      3 years ago

      Hi NomisSimon 

      It seems to be working for me, unless I have misunderstood your request:


      In the example above the Revenue measure is only displaying the revenue for the filtered project numbers.

      Did you definitely create a measure and not a column?