Count of first time this week

[fever003]

Hi

I have a data showing accounts, week, and status of accounts.

This is the expected output. I amtrying to create a measure for the right most column below. Appreaciate your help!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[fever003]

Hello, thank you for helping me out. I am just trying to understand the measure you have created because I am trying to apply it to the data which has a similar structure as example I shared.

I have tried RANKX and almost getting there, but how saw that you used SUMMARIZE. 

[Ashish_Mathur]

Hi,

If my solution helps, please mark it as Answer.

[fever003]

Sort of. Will mark as solution.

[fever003]

Could anyone help me please?

[fever003]

Well i guess nobody could help me with this then