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...
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.