Forum Discussion

Donnajones's avatar
Donnajones
Frequent Visitor
4 years ago
Solved

Working with Quick Measures

I have been working on what should be a simple quick measure for hours, and need help

 

I have a list of staff and and projects.  I want to see the AR Total for only the staff selected but it continullay show me the AR total on my card

 

This is the measure I created but it doesn't appear to work

 

AR Balance total for Staff =
CALCULATE(SUM('Table1 (2)'[AR Balance]), ALLSELECTED('Staff'[Staff]))
 
Can anyone help?
Need Help

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    Donnajones what is the relationship between table that contains AR data and the Staff table?

     

     

    ✨ Follow us on LinkedIn and  to our YouTube channel

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

  • Donnajones's avatar
    Donnajones
    Frequent Visitor
    4 years ago

    Client ID is the relationship.  There is no Staff in the AR table

     

     

  • Donnajones's avatar
    Donnajones
    Frequent Visitor
    4 years ago

    this is my new measure

    AR Balance total for File Holder =
    CALCULATE(
        SUM('AR Data'[AR Balance]),
        ALLSELECTED('Projects'[File Holder])
    )
    • luohen's avatar
      luohen
      Resolver II
      4 years ago

      Hi Donnajones ,

      Could you please provide some sample data(exclude sensitive data) with Text format and your expected result with special examples and screenshots. It is better if you can provide me a simplified pbix file. Thank you.