Forum Discussion
Dynamic Grouping on Sum
Referred here from another thread, try this:
OK, based on the data in the other post, I created a Category table with:
Category
0-50 percent 51-75 percent 75-100 percent And a measure like this:
Measure = VAR __Date = MAX('Table'[date]) VAR __Category = MAX('Categories'[Category]) VAR __Low = SWITCH( __Category, "0-50 percent",0, "51-75 percent",.51, "75-100 percent",.75 ) VAR __High = SWITCH( __Category, "0-50 percent",.5, "51-75 percent",.74, "75-100 percent",1 ) VAR __tmpTable = SUMMARIZE('Table','Table'[userid],"__Percent",MAX('Table'[profilepercent])) RETURN COUNTROWS(FILTER(__tmpTable,[__Percent]>=__Low && [__Percent]<=__High))PBIX is attached.
Where does the date on your x-axis come from? Generally, the way you do this is to use a VAR to grab the MAX of the date on your x-axis. Then it's a simple FILTER. Also, you might want to check out my quick measures here that do some fancy stuff with dates and categorizing stuff in those dates.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
Exact Scenario - I really need this urgent. Thanks in Advance
Table I have
User 1 have avatar - legend from jan 1 till jan 14 and master from jan 15 onwards
User 2 have avatar - master from jan 1 till jan 14 and legend from jan 15 onwards
User 3 have avatar - tyro from jan 6 till jan 12 and master from jan 12 onwards
I want to show this on a line trend with avatar on being the legend showing count of users in different avatars for the timeline (all days from first date till selected date)
Lets say selected date is jan 20
legend will have one count from jan 1 till 20
master will have one count from jan 1 till jan 11 and two count from 12 till 20
tyro will have one count from jan 6 till jan 11