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
    )
)

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello m3tr01d ,

 

Thank you very much for your response.

This solved me the problem of measureB but still cannot figure out how to compute measureC, which unfortunately is my final table.

 

Any ideas would be much appreciated.

 

Best regards,

m3tr01d's avatar
m3tr01d
Continued Contributor
5 years ago

Hmm,
maybe try 

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

 
At this point, I would need to do some more tests with data.