Forum Discussion

KamilRetkiewicz's avatar
KamilRetkiewicz
Icon for Helper I rankHelper I
1 year ago

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 Factor...
Need Help
KamilRetkiewicz's avatar
KamilRetkiewicz
Icon for Helper I rankHelper I
1 year ago

Hi,

After fix i have sth like this: 

maybe it is because i took value from another table? Relationship with mapped table is correct, idk what doesnt work

shafiz_p's avatar
shafiz_p
Icon for Super User rankSuper User
1 year ago

KamilRetkiewicz  Try below code:

YourMeasureName2 =
IF(
    SELECTEDVALUE (MAPPING_YTG_3[Name_ACCOUNT])  = "FCF Including Factoring",
    [YourMeasureName],
    1
)

 

Hope this helps!!

If this solved your problem, please accept it as a solution!!

 

Best Regards,
Shahariar Hafiz