Get mesure value as a varible

[Wresen]

Hi all.

I hope i have poested this in the right forum, this is a little jungel to me 🙂

I need little help , have tried to google the answer but have not found anything good,.

I have a calculated measure were i take 2 values that are linked to the same month and dived them.

Now i want to use that result from that calculation in the rest of the months (i want to have the resalut as a varible that i can use)

Now it is linked the the month that i use when i divided the 2 numbers and when i try to use the resualt i will only work on the same month that i used to get the diveded value.

I hope you understand what i mean.

/Thanks so much.

[kentyler]

MyMeasure =

VAR firstDivisionResult = DIVIDE ( firstMonthValue, firstMonthValue2)

VAR secondMonthResult = DIVIDE( secondMonthValue, firstDivisionResult)

RETURN secondMonthResult

[Wresen]

Thanks so much for a quick answer.

I am not sure but i do not get it to work, i think i may have beed bad explainign what i am looking to do,

I have diveded "Value" / "Count" and that gave me" Value of one"

"Mesure 3" is "Amount" * "Value of one"

I would like to be able to use Value of one (0,0,3448) to the rest of the rows in Measuer 3

If this would work 201906 , Measure 3 would say 5,2 (0,03448 * 151)

[v-frfei-msft · Accepted solution]

Hi @Wresen ,

To create two measures as below.

Value of one = 
VAR val =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Value] <> BLANK () )
    )
VAR amount =
    CALCULATE (
        SUM ( 'Table'[Count] ),
        FILTER ( ALL ( 'Table' ), 'Table'[Value] <> BLANK () )
    )
RETURN
    DIVIDE ( val, amount )

Measure = MAX('Table'[Amount])*[Value of one]

[Wresen]

Thanks so much , that worked perfectly.

Really appriciate the help. 🙂

[kentyler]

Since you want to reference other values in the same row, perhaps this is a case for calculated columns. 

Once you have the "Value of One" column you can reference it in other columns

[Wresen]

Thanks again for all the help.

But i do not think that will work , 

"Amount" "Value" and "Count" are all calculated values from a table. (there is a few slicers options that give you these numbers)

I also have a slicer that makes you change "THIS MONTH" The slicer is on 201905  

/Thanks