Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure needing different context

Dear community,    I would appreciate some help in the following issue. I have aggregated data about some stores. I have several more columns describing the stores but, for the sake of the example...
General Comment
  • m3tr01d's avatar
    m3tr01d
    5 years ago

    You could change your calculation like this :

    CALCULATE(
    DISTINCTCOUNT('Table'[Store]),
    FILTER(
        ALL( 'Table'[Store] ),
        [measureA] > 0.05
    )
)

     

m3tr01d's avatar
m3tr01d
Continued Contributor
5 years ago

You could change your calculation like this :

CALCULATE(
    DISTINCTCOUNT('Table'[Store]),
    FILTER(
        ALL( 'Table'[Store] ),
        [measureA] > 0.05
    )
)

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello m3tr01d , 

 

In fact, the measure above solve both questions, the result does not change if I add or delete the Store column to the table.

 

I will open another post because I do not want to add noise, but I really do not understand what is happening here behind the scenes and why does this work. If anybody would be so kind as to stop by I would appreciate it. 

 

Best regards,