Reply
Highlighted
Frequent Visitor
Posts: 4
Registered: Thursday

Count of first time this week

[ Edited ]

Hi

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

1.png

 

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

2.png

Frequent Visitor
Posts: 4
Registered: Thursday

Re: Count of first time this week

Could anyone help me please?

Frequent Visitor
Posts: 4
Registered: Thursday

Re: Count of first time this week

Well i guess nobody could help me with this then

Super User
Posts: 3,324
Registered: ‎01-14-2017

Re: Count of first time this week

Hi,

 

You may download my PBI file from here.

 

Hope this helps.

 

Untitled.png

Frequent Visitor
Posts: 4
Registered: Thursday

Re: Count of first time this week

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. 

Super User
Posts: 3,324
Registered: ‎01-14-2017

Re: Count of first time this week

Hi,

 

If my solution helps, please mark it as Answer.