Iterating a measure value based on attribute

[Anonymous]

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

[v-juanli-msft · Accepted solution]

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]

@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]

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]

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.

[parry2k]

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