Forum Discussion
Conditional measure
Hi Guys, I had a following problem with measure: YourMeasureName = var FCFOperations = CALCULATE(SUM(YTG3_FCF[AmountEXCANDONEOFF]), YTG3_FCF[CATEGORY] = "FCF Operations including Facto...
You can try:
YourMeasureName2 =
IF (
MAX(YTG3_FCF[CATEGORY]) = "FCF Including Factoring",
CALCULATE([YourMeasureName], YTG3_FCF[CATEGORY] = "FCF Including Factoring"),
1
)
You can also try adding a column to debug what values are actually being returned for YTG3_FCF[CATEGORY] in the matrix by using a simpler measure like:
TestMeasure = MAX(YTG3_FCF[CATEGORY])
This will help you understand what category is being evaluated in each row.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Now got this.
