Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello everyone,
I am trying to have a table written in dax, with MIN and MAX values of a measure.
I have a measure that varies based on several slicers; I woul dlike to have a table that automatically creates 4 clusters based on this measure.
I have built a table with 4 columns (id, Segment, Min, Max) like so :
And it doesn't work as it seems that the table cannot accept a measure for the values.
As soon as I replace the table's code by hard coded values, it works.
Any help would be much appreciated!
Thanks,
Stan
You should not create calculated columns from measures. You cannot create calculated tables from measures (unless it is a single row single column table). In both cases your measure will use a non-existent filter context.
The maximum you can do is create a table variable as an intermediate step in a measure definition.
Measure a =
Var b= summarize (c,[d])
Return countrows(b)
Summarize is not able to be dynamic, even built with a measure unfortunately.
Thanks anyway!
That's news to me. Please try it out.