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...
That makes sense. As what I've mentioned, using a related table to filter another table where the row being filtered doesnt exist will return blank by default. It is looking for either the other "FCF Including Factoring" but it isnt there so you need to use a filter modifier so it returns the desired value. It is like having a Gross Profit row in a table but there is only Revenue and Expense rows in the other tables. The measures will return blank for that Gross Profit row. The sample formula is already in my previous reply.
Thank you for your answer. I used both measures and unfortunately in both cases I got a value of 1
Instead of Category, please try using Name_Account.