Forum Discussion
Return Value from Table based on Measure Condition
I did think it was a column. Here is a different expresssion that works with a measure. Just replace 0.1 with 0.9 for the other measure.
10 Pct Month =
VAR summary =
ADDCOLUMNS (
SUMMARIZE (
Data,
Data[Project],
Data[Location],
Data[Month]
),
"@PctComplete", [% Complete Measure]
)
RETURN
MINX (
FILTER (
summary,
[@PctComplete] >= 0.1
),
Data[Month]
)Regards,
Pat
mahoneypat - Thank you for responding.
I used the below "measure" calculation as per your suggestion, and i get the error message: A function 'CALCULATE' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
Kindly note the "% Complete" is a calculated measure; and not part of the table.
I did think it was a column. Here is a different expresssion that works with a measure. Just replace 0.1 with 0.9 for the other measure.
10 Pct Month =
VAR summary =
ADDCOLUMNS (
SUMMARIZE (
Data,
Data[Project],
Data[Location],
Data[Month]
),
"@PctComplete", [% Complete Measure]
)
RETURN
MINX (
FILTER (
summary,
[@PctComplete] >= 0.1
),
Data[Month]
)
Regards,
Pat