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.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous your question is not fully clear, Did you calculated "MeasureA" as measure in the model? What is the expression for it? What you are trying to achieve? What you mean by "MeasureA" = 3

  • 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 

    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Anonymous you can surely create a table with those measure then use it, without knowing the full details it is very hard to say whether creating the table is right approach or you should be using these measures in other measure to achieve the goal.

       

      Your question is very vague and very hard to answer.

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