How would I format a matrix table with different date filters?

[KA95]

Hi there,

I have a simple matrix table that counts user id's that are active within a date filter which are then counted by a specific category (gold, silver, and bronze), here is the example below:

However, I want to make it so it has different date row columns, for example, like below:

I currently have a simple count measure for the ID's (the value in the table) that is being used called (User Count). I tried to implement a measure that counts the User ID's in the last 30 days of [active_date] to match the first row column but that didn't work. Is there any way this is acheivable? 

I'm just hoping someone could point me in the right direction because I'm stuck on this one I'm afraid. Will I have to create several different measures for each row column on the left hand side? And how would I do it so it can fit in correctly? Or is there an easier way to do it completely? 

[amitchandak]

@KA95 , You have to create the measure of what you have on the rows. And You can use "show on row" in matrix visual. I doubt you can show the total before.

You can also explore calculation groups

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

[KA95]

Hi @amitchandak 

Thank you for the reply, so is there a chance I can move a measure like this on a row column? 

Last 30 days =

CALCULATE (

[User Count],

DATESINPERIOD ( 'Candidate Activity'[active_date], MAX ( 'Candidate Activity'[active_date] ), -30, DAY )

)

Currently this is the only way I can format it: 

Is there no way I can have this on the left hand side like in my drawing example? 

[v-kkf-msft · Accepted solution]

Hi @KA95 ,

Please enable the "Switch values to rows" option in Format visual.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[KA95]

Thank you very much @v-kkf-msft that worked a treat!