using SELECTEDVALUE in a calaulated table

[lilian7300]

Hi,

I met the following problem, appreciate if anybody can help with that.

1. I create a table with the following DAX code:

SlicerValue = GENERATESERIES(1,10)

2. I use SlicerValue as a slicer

3. I use a measure called cal1

cal1 =

var v1=SELECTEDVALUE(SlicerValue[Value])

return sumx(Cal,Cal[Value]*v1)

it returns the correct result I want.

4. I want to create a calculated table:

Table =

SELECTCOLUMNS(Cal,"cal1",Cal[cal1])

The result is  blank. What I expect is it should display the values like (8,12,16,20,24...) .

How can I make it work?

[mahoneypat]

While you can't make a calculated table that is dynamic to your slicer, but you can make a virtual table in a measure like this one.

VirtualTableMeasure =
VAR v1 =
SELECTEDVALUE ( SlicerValue[Value] )
VAR _table =
ADDCOLUMNS ( GENERATESERIES ( 1, 10, 1 ), "@value", v1 * [Value] )
RETURN
SUMX ( _table, [@value] )
// or do some other analysis on this virtual table

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[lilian7300]

Thanks for your reply. I tried your DAX code but it comes the error message "The expression specified in the query is not a valid table expression."

VirtualTableMeasure =

VAR v1 =SELECTEDVALUE ( SlicerValue[Value] )

VAR _table =

ADDCOLUMNS (GENERATESERIES( 1, 10, 1 ), "@value", v1 * [Value])

RETURN

SUMX ( _table, [@value] )

[amitchandak]

@lilian7300 , Measure used in the table will not respond to selected values.

[lilian7300]

So sad to hear that, it's very important for me to develop a dynamic calaulated report.

Why Power BI can't do that???