Forum Discussion
Solved
DAX Measure which Filter values from Table
Hi all! I am trying to achieve two measures which give me the following: The total Amount Invoiced of Projects which have an Amount Invoiced greater than 100K. A count of projects which hav...
Please try this measure expression
Invoiced Over 100k =
VAR vSummary =
SUMMARIZE (
'Project Transactions',
'Project Transactions'[Project Name],
"cInvoiced", SUM ( 'Project Transactions'[Amount Invoided] )
)
RETURN
SUMX (
FILTER (
vSummary,
[cInvoiced] >= 100000
),
[cInvoiced]
)For your count measure, just change the Return to COUNTROWS(FILTER(vSummary, [cInvoiced] >=100000))
Regards,
Pat
Thank you both for tour suggestions 🙂