Forum Discussion

ChuckChuck's avatar
ChuckChuck
Icon for Helper I rankHelper I
5 years ago

Max Age for Bottom 80%, Based On Current Filter Context

I have a table with millions of records where I'm trying to dynamically arrive at the max [Age] by [As of Date], but filtered to only where the [Running Total] is less than 80% of the [Date Total]. S...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

ChuckChuck can you share what existing measure you are using? Also if possible share sample pbix file to look into it.

 

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.⚡

ChuckChuck's avatar
ChuckChuck
Icon for Helper I rankHelper I
5 years ago

Hello parry2k ,

 

PBIX: https://1drv.ms/u/s!AqaBEhuP2H_olAOBkyTxlctZXCWa?e=ONJJxS

Measure: 

Max Age <80% Threshold =
MAXX(FILTER(SUMMARIZE('Table', 'Table'[As of Date], 'Table'[Age], "RT %", [Running Total %]), [Running Total %]<.8), 'Table'[Age])
 
When this measure is used in my dataset that is millions of rows, it takes a very long time to return the results.