Forum Discussion
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 count ID based on condition MeasureA=3. Is this possible ??
| ID | Category | MeasureA |
| 1 | Transport | 1 |
| 2 | Health | 3 |
| 3 | Food | 3 |
| 4 | Education | 1 |
Thanks for your help.
Regards,
Prabin
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
MaggieCommunity 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.
5 Replies
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
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 NepakAnonymous 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.
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
MaggieCommunity 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.
