Working with Quick Measures

[Donnajones]

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?

[Donnajones · Accepted solution]

I resolved my issue.  thanks

[Donnajones]

this is my new measure

AR Balance total for File Holder =

CALCULATE(

    SUM('AR Data'[AR Balance]),

    ALLSELECTED('Projects'[File Holder])

)

[luohen]

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.

How to upload PBI in Community

[Donnajones]

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

[parry2k]

@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.