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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

In my model i have few measures which are calculated on the fly.Eventually they produce values ranging from 1 to 10 but since those are measures ,i am not able to store their values.

 

I just wanted to know whether we can store them in a table and then use those values to create other aggregations as well based on their result

Regards
Prabin Nepak 

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

Hi Anonymous 

If you'd like the filter value to change dynamically, you could create a what-if parameter in Power BI Desktop,

Then use this parameter measure in the measure

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

 

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.