help with measures & queries

[MP_123]

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!

[v-sihou-msft]

@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,