Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

help with measures & queries

hi

i have a problem

i created new measure with filter:

Rendered = CALCULATE(sum(uus[NumOf_Unique_Rendered_Monthly]), FILTER(uus, uus[Combination_IDE]=[Measure 8]))

Measure 8 is: Measure 8 = if([1111Combination]="1,1,0,0,0",26,20)

1111Combination] is another measure but it never mind.

when i check the value of measure 8 with card visual, i see 26.

when i check the query in the DB, the measure rendered is using the value 20.

 

has someone have an idea?? 

thanks!

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    MP_123

     

    In this scenario, the [1111Combination] you applied in IF() should be a single value, I assume it should be a measure. In Card Visual, it should return measure value on aggregation level. When you run query against database, it may calculate on detail slicing level. 

     

    If you still have any question, please share your query and the expression of [1111Combination].

     

    Regards,