Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
24 | |
19 | |
14 | |
10 | |
7 |