Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Using 'SELECTEDVALUE' inside 'CALCULATE'

I am trying to use 'SELECTEDVALUE' inside the 'CALCULATE' function and Power BI is showing an error: "A function 'SELECTEDVALUE' has been used in a True/False expression that is used as a table filte...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Thanks for your reply amitchandak .

     

    I didn't know that I could use another 'FILTER' inside CALCULATE. Your measure had some unexpected behavior in the chart. I could solve the problem using the following measure:

    Measure_01 =
    CALCULATE(
    SUM(Meta_Comp_Alim[Meta_Alim_Diaria]),
    Meta_Comp_Alim[COD_DEP] = VALUES(Tab_Auxilar_COI[Cod_Item]),
    FILTER(
    ALL(Date_Table),
    Date_Table[Date_Column] <= MAX(Date_Table[Date_Column])
    )
    )
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , seems strange

 

try like

 

Measure_01 =
CALCULATE(
SUM(Meta_Comp_Alim[Meta_Alim_Diaria]),
filetr(Meta_Comp_Alim,Meta_Comp_Alim[COD_DEP] = SELECTEDVALUE(Tab_Auxilar_COI[Cod_Item])),
FILTER(
ALL(Date_Table),
Date_Table[Date_Column] <= MAX(Date_Table[Date_Column])
)
)

 

 

If this does not help
Can you share  a sample pbix after removing sensitive data.