Forum Discussion

jhimelic's avatar
jhimelic
Frequent Visitor
6 years ago
Solved

filtering a calculated / temporary table to generate a histogram

hello all   i have created a variable that stores a table which i then use to calculate some parameters that arent native in my raw tables. up until now, all of my measures referencing this tempora...
Need Help
  • jhimelic's avatar
    jhimelic
    6 years ago

    thank you for referencing the helpful series of articles. after going through them and working on this issue some more, i was able to stumble across a working solution: 

     

    the tweak i made that worked is the following

     

    =

    VAR Temp_Table =

    SUMMARIZE(original table, original table [property i am using to count across], "new column name", expression)

    RETURN

     

    countrows(filter(Temp_Table,FILTER(Temp_Table,[new column name] >= bintable[Min_Boundary] && [new column name] < bintable[Max_Boundary]))

     

    this small tweak was all i needed. 

jhimelic's avatar
jhimelic
Frequent Visitor
6 years ago

thank you for referencing the helpful series of articles. after going through them and working on this issue some more, i was able to stumble across a working solution: 

 

the tweak i made that worked is the following

 

=

VAR Temp_Table =

SUMMARIZE(original table, original table [property i am using to count across], "new column name", expression)

RETURN

 

countrows(filter(Temp_Table,FILTER(Temp_Table,[new column name] >= bintable[Min_Boundary] && [new column name] < bintable[Max_Boundary]))

 

this small tweak was all i needed.