Forum Discussion

PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
4 years ago

Selected Value not returning the value

Hi,   What seemed like a simple solution has taken few hours now and still cant figure out the SelectedValue issue.  I have a Product table connected to a Promotions table with a relation 1 - many...
Need Help
PBIfanatic's avatar
PBIfanatic
Icon for Helper V rankHelper V
4 years ago

thanks Fowmy 

Is there a way to create a column on the fly based on the selected value from a filter?

 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

PBIfanatic 

Yes, absolutely, you can use many table functions in DAX depending on your situation, for example

FILTER (
    ADDCOLUMNS (
        VALUES ( 'Date'[Calendar Year] ),
        "@Amount",              [Sales Amount],
        "@Quantity Wrong",      SUM ( Sales[Quantity] )
     ),
    [@Amount] > SELECTEDVALUE( Parameter[Amount] )
)