Forum Discussion
Conditional measure
Does FCF Including Factoring exist in your fact table or is it just an extra row in MAPPING_YTG3 table? If it doesn't, it shows blank because it is trying to filter YTG_3 but it doesn't exist there or it doesn't exist in the fact table. I would try the following:
IF (
SELECTEDVALUE ( YTG3_FCF[CATEGORY] ) = "FCF including Factoring",
CALCULATE ( [YourMeasureName], REMOVEFILTERS ( YTG3_FCF[CATEGORY] ) ),
1
)
OR
IF (
SELECTEDVALUE ( YTG3_FCF[CATEGORY] ) = "FCF including Factoring",
CALCULATE ( [YourMeasureName], REMOVEFILTERS ( TableNameThatContainsName_Account ) ),
1
)
OR
Hi,
This is about : MAPPING_YTG3
In rows we have [Name_ACCOUNT] but measure reffers to YTG3_FCF[CATEGORY] where is all data.
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.