Forum Discussion

mdgene's avatar
mdgene
Icon for Helper I rankHelper I
1 year ago
Solved

Unable to use selectedvalue variable in a calculated table

Hi, I am trying to compare different snapshots in a table by allowing users to select the dates on two different filters. but I got stucked on the first step. when I use SELECTEDVALUE as a variable a...
  • Kedar_Pande's avatar
    Kedar_Pande
    1 year ago

    SELECTEDVALUE works in measures and visuals, where the context is dynamically applied by slicers or filters in the report. However, calculated tables are static after being created, and they are not updated dynamically when slicers are applied. Hence, using SELECTEDVALUE in a calculated table won't update the table in response to slicers.

     

    > If you want the table to update dynamically based on the user's selection of Dw_snapshotdate from a slicer, you must create a measure rather than a calculated table.

     

    Create a measure to filter dynamically:

    Filtered_UCode_Measure = 
    VAR CurrentSnap = SELECTEDVALUE(Snapshoptdate[Dw_snapshotdate])

    RETURN
    CALCULATE(
    SELECTCOLUMNS(
    'R_Yearly_Summary_Measures',
    "UCode", 'R_Yearly_Summary_Measures'[Ucode]
    ),
    'R_Yearly_Summary_Measures'[Dw_snapshotdate] = CurrentSnap
    )

    💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
    Cheers,
    Kedar
    Connect on LinkedIn