Forum Discussion
Summarize Table as Measure
j_gan2022 , Sorry Some mistake
Option one is a new table
If you need measure
meausre =
VAR _table = SUMMARIZE(Data, Data[Student ID], "Total Attendance", COUNTROWS(Data) )
var _count = countx(filter(_table, [Total Attendance] >=Min(MasterGroup[Min Value] ) && [Total Attendance] <=max(MasterGroup[Max Value] )),[Student ID])
return
_count------
If you need table
Table = VAR Table = SUMMARIZE(Data, Data[Student ID], "Total Attendance", COUNTROWS(Data) ) return Addcolumns(Table , "Bucket" [Total Attendance] <= 10, " 0 -10" , [Total Attendance] <= 20, " 10 -20" , [Total Attendance] <= 30, " 20 -30" , [Total Attendance] <= 40, " 40 -40" , //Add other )
j_gan2022 , You should use add columns and add between range
Var Result = Addcolumns(Table , "Bucket"
[Table] <= 10, " 0 -10" ,
[Table] <= 20, " 10 -20" ,
[Table] <= 30, " 20 -30" ,
[Table] <= 40, " 40 -40" ,
//Add other
)
or explore this , place of margin you have total student
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
amitchandak sorry i dont understand how this works.
Var Result = Addcolumns(Table , "Bucket"
[Table] <= 10, " 0 -10" ,
[Table] <= 20, " 10 -20" ,
[Table] <= 30, " 20 -30" ,
[Table] <= 40, " 40 -40" ,
//Add other
)How do i link it to my group? Please advise. Thanks. I need it to be able to change according to slicer.
j_gan2022 , Sorry Some mistake
Option one is a new table
If you need measure
meausre =
VAR _table = SUMMARIZE(Data, Data[Student ID], "Total Attendance", COUNTROWS(Data) )
var _count = countx(filter(_table, [Total Attendance] >=Min(MasterGroup[Min Value] ) && [Total Attendance] <=max(MasterGroup[Max Value] )),[Student ID])
return
_count------
If you need table
Table = VAR Table = SUMMARIZE(Data, Data[Student ID], "Total Attendance", COUNTROWS(Data) ) return Addcolumns(Table , "Bucket" [Total Attendance] <= 10, " 0 -10" , [Total Attendance] <= 20, " 10 -20" , [Total Attendance] <= 30, " 20 -30" , [Total Attendance] <= 40, " 40 -40" , //Add other )
