Selected Value not returning the value

Question

Hi,&nbsp;What seemed like a simple solution has taken few hours now and still cant figure out the SelectedValue issue.&nbsp;I have a Product table connected to a Promotions table with a relation 1 - many.And have a filter for Promotion in the report.&nbsp;I need to create few calculated columns in the Product table using SelectedValue on the filter but I dont get the selected value of the filter. It just returns blank.&nbsp; Is there any restriction on using the SelectedValue function, or is there a different way to use it?&nbsp;&nbsp;Product IDMeasure 1&nbsp;11211122111132&nbsp;Product IDPromotion11Promo111Promo211Promo3111Promo1111Promo4&nbsp;

fowmy · Answer

PBIfanatic&nbsp;If you are trying to create a calculated column then you cannot access what is selected in the report from any filter. This is because adding columns take place in the data modeling stage, once you complete that the data load and the model are ready for use in the report.&nbsp;

jdbuchanan71 · Answer

PBIfanatic&nbsp;
Calcualted columns are only updated when the model is refreshed.&nbsp; A filter (like a silcer) on a report won't do anything to a calculated column.&nbsp; Can you give us more information about what you are trying to accomplish?
Take a look at this post, it has a lot of information about what we need to help you with your question.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150
&nbsp;

pbifanatic · Answer

thanks&nbsp;Fowmy&nbsp;Is there a way to create a column on the fly based on the selected value from a filter?&nbsp;

pbifanatic · Answer

hi&nbsp;jdbuchanan71&nbsp;if I had known this would have framed it differently.&nbsp;I want to create a flag against each product based on some numerical values thats associated to the product(these values aer in other tables) for the Promotion filter selection.&nbsp;&nbsp;&nbsp;

fowmy · Answer

PBIfanatic&nbsp;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] &gt; SELECTEDVALUE( Parameter[Amount] )
)
&nbsp;

Forum Discussion

Selected Value not returning the value

6 Replies

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

Return selected values in string?

Return "Specific value" from table 1, if not found, return value from table 2

Product ID	Promotion
11	Promo1
11	Promo2
11	Promo3
111	Promo1
111	Promo4