The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I have a table called Main Claim Data and within that I have a numeric field called Highest Estimate. I want to create a measure that totals the Highest Estimates for those records where the field Repudiated Flag (which is a flag field) is True.
Any ideas?
I am new to DAX and struggle so thank you for your patience .
Solved! Go to Solution.
Hello there @spandy34 ! Hope this is what you are looking for:
Total Estimates =
SUMX (
FILTER ( 'Main Claim Data', [Repudiated Flag] = TRUE () ),
[Highest Estimates]
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
Thanks you thats worked a treat - really appreciate your help
Hello there @spandy34 ! Hope this is what you are looking for:
Total Estimates =
SUMX (
FILTER ( 'Main Claim Data', [Repudiated Flag] = TRUE () ),
[Highest Estimates]
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
You can also check out my LinkedIn!
Best regards,
Gonçalo Geraldes
@goncalogeraldes do you think you will be able to help with my other post about filtered measures ?
User | Count |
---|---|
25 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |