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 ,

     

    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.

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