How to use "Summarize" function with only same ID (I guess use FILTER)?

[JustinDoh1]

I am sharing my Pbix file here.

I am trying to modify this measure (Refused_Historical) so that it considers output if it is same Step only.

So, for this case, I am trying to find output when Step = 1 (not including Step = 2 this case).
Currently, the output is 2, instead of 1, and that messes up when it comes to other calculation (SUMX) later on visual.

How do I express so that it only counts when Step is same?

Thanks for help again.

[Greg_Deckler · Accepted solution]

@JustinDoh1 Try:

VAR __Step = [Step]

if a column or MAX([Step]) if measure.

Then in your SUMMARIZE do SUMMARIZE(FILTER('Table1',[Step]=__Step).....

[JustinDoh1]

@Greg_Deckler Thank you so much again! I know I am getting better hands on DAX now 🙂