Forum Discussion

gtamir's avatar
gtamir
Post Patron
8 years ago
Solved

Using a Measure in a Measure

Hi,

 

MaxSale = MAX(RandomNumbers[Value]) is the highest value in the column value

Decile1 = [MaxSale]/10 is the Decile (98)

 

Count in 1St Decile = countrows(CALCULATETABLE(RandomNumbers,RandomNumbers[Value] >0 && RandomNumbers[Value] <=98)) this works.

 

Count in 1St Decile(2) = countrows(CALCULATETABLE(RandomNumbers,RandomNumbers[Value] >0 && RandomNumbers[Value] <=98)) This works too

 

What to do to use the "Decile1" measure instead of one of the values?

 

Thanks Giora

Need Help
  • OwenAuger's avatar
    OwenAuger
    8 years ago

    Hi gtamir

     

    The simplest fix is probably to store [Decile1] in a variable:

    TEST =
VAR Decile1_Var = [Decile1]
RETURN
    COUNTROWS (
        CALCULATETABLE ( RandomNumbers, RandomNumbers[Value] > Decile1_Var )
    )

2 Replies

  • OwenAuger's avatar
    OwenAuger
    Super User
    8 years ago

    Hi gtamir

     

    The simplest fix is probably to store [Decile1] in a variable:

    TEST =
VAR Decile1_Var = [Decile1]
RETURN
    COUNTROWS (
        CALCULATETABLE ( RandomNumbers, RandomNumbers[Value] > Decile1_Var )
    )