Forum Discussion

ebbrey's avatar
ebbrey
Frequent Visitor
6 years ago
Solved

SUMX with filter using SELECTEDVALUE

Hey   Im fairly new to Power BI and im trying to solve SUMX to a non-related table.   The table im trying to get correct number from has info like this: Elements Table: Projectnumber Co...
Need Help
  • lc_finance's avatar
    lc_finance
    6 years ago

    Hi ebbrey ,

     

     

    To have the measure based on the currently selected project, you'd need to use a calculated measure instead of a calculated column.

    Does this help you?

     

    If it doesn't, can you share a sample Power BI file?

    You can share it via One Drive, Google Drive or a similar tool.

     

    Regards,

     

    LC

    Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com

lc_finance's avatar
lc_finance
Icon for Solution Sage rankSolution Sage
6 years ago

Hi ebbrey ,

 

 

To have the measure based on the currently selected project, you'd need to use a calculated measure instead of a calculated column.

Does this help you?

 

If it doesn't, can you share a sample Power BI file?

You can share it via One Drive, Google Drive or a similar tool.

 

Regards,

 

LC

Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com

  • ebbrey's avatar
    ebbrey
    Frequent Visitor
    6 years ago

    lc_finance 

     

    Thanks for your reply to my question and pointing me away from trying to use selectedvalue in a column.

     

    I ended up getting it to work by using a referance table wich i could relate to the project table and get the filter i needed.

    • lc_finance's avatar
      lc_finance
      Icon for Solution Sage rankSolution Sage
      6 years ago

      I'm glad you found a solution for it!

       

      Do not hesitate if you have more questions.

       

      LC

      Interested in Power BI and DAX tutorials? Check out my blog at www.finance-bi.com