Writing Values in counted rows

Hi Anonymous 

I think your data model will cause the issue. Let's see your table screenshot.

You want to count the value of MS in 28 days after the ”MI“ type and group them. However, we can see that you have many "MI" type with close time in your screenshot. 

For example in red box,  Created on of MI1 = 2019/09/30, Created on of MI2 = 2019/10/02. So Ms in 2019/10/04 , 2019/10/08 ...  will in both groups. So you may get the wrong result. 

To add a group number for MI, you can build a rank just like in my measure by rankx function.

RankMI = 
            RANKX (
                FILTER ( MS_MI_Meldungen, MS_MI_Meldungen[NOTI Type] = "MI" ),
                MS_MI_Meldungen[NOTI Created On],
                ,
                ASC
            )

This will only create an index by "NOTI Created On" for values whose "NOTI Type" = "MI".

Do you want to show all groups for the MS in different groups?

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.