Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Memory issue when adding a filter

Hi, I am currently trying to filter out all rows that show $0.00 under the Total AR column. Below are screenshots of the before and after.   I highlighted the Visit Description data but ther...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
parry2k's avatar
parry2k
Super User
3 years ago

Anonymous yes DAX operations can have a performance impace and memory issue. There could be many reasons, mainly:

 

- how your data model looks like (relationship between tables)

- what kind of dax expression is used in the measure?

 

There are many videos/blogs on performance tuning which does address these kinds of issues. Just google it.

 

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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

parry2k 

Hi,

This is my measure

 

Total AR = SUM(ChargeDetail[PatientBalance]) + [Insurancebalancefinal]

 

and 

Insurancebalancefinal = sum(ChargeDetail[expectedcharge]) - [patientpayment] - [insurancepayment]
patientpayment = calculate(sum(PaymentDetails[PaymentAmount]),Payments[PaymentSource] = 1)
insurancepayment = calculate(sum(PaymentDetails[PaymentAmount]), Payments[PaymentSource] = 2)

 

There is  many to many relationship between ChargeDetail and PaymentDetails tables