Interactive table calculations based off of slicer selection
I'm trying to create a dynamic dataset in Power BI. What i want to do is as far as i am aware not possible in Power BI: I want to set a column in the query table to read in what the slicer has been selected for e.g. my formula in the query would be: 1000* slicer value. this column would then be used by subsequent columns to calculate an output. However as said everything i know about Power BI says you cannot read dynamic data into the query. So what i wanted to do was create a number of measures that create a new table dataset starting from that first point e.g. have a measure running from the slicer to do the initial calculation and then adding measures to that measure to complete the rest of my calculations e.g. i want to replicate the table i would have in the query but in terms of measures.