Forum Discussion

KamilRetkiewicz's avatar
KamilRetkiewicz
Helper 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 Facto...
Need Help
shafiz_p's avatar
shafiz_p
Super User
1 year ago

Hi KamilRetkiewicz  Seems like the SELECTEDVALUE function not returning the expected value. See the difference in i of including word marks in red. Check this differences.

 

 

 

If not solved your problem, please share PBIX file or sample data.

 

Best Regards,
Shahariar Hafiz

KamilRetkiewicz's avatar
KamilRetkiewicz
Helper 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
    Super 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

    • KamilRetkiewicz's avatar
      KamilRetkiewicz
      Helper I
      1 year ago

      unfortunately it didn't work:/