Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Iterating a measure value based on attribute

Hi,   Am trying to iterate a measure value and count the attributes based on satisfying condition on measure, for ex: if i have a table with measure(measure A) calculated dynamically, i need to cou...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    Add columns and measures in a table visual

    Create another measure based on one measure

    Measure 2 = CALCULATE(COUNT(Sheet7[ID]),FILTER(ALL(Sheet7),Sheet7[Measure]=3))

    When changing [Measure] value, [Measure 2] value changes accordingly.

     

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Add columns and measures in a table visual

Create another measure based on one measure

Measure 2 = CALCULATE(COUNT(Sheet7[ID]),FILTER(ALL(Sheet7),Sheet7[Measure]=3))

When changing [Measure] value, [Measure 2] value changes accordingly.

 

 

Best Regards
Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.