Forum Discussion
Store result from table visual as calculated table
Hi,
I've never used calculated tables/columns before, but I need to use the result of a complex measure in further calculations, and as I understand it, that's what you use calculated tables for.
If I drop 2 columns (Store[Store], and Product[Product]) and 1 measure ([Score]) in a table visual, that almost instantly returns the table I want. How do I keep this table as a calculated table in my model? I need help with the correct DAX :)
The measure is no simple aggregation, but a result of several rankings of all stores including lots of CALCULATE()'s and some variables.
I tried SUMMERIZE(), and SELECTCOLUMNS() to build the table, but i run into memory issues, or the returned values are incorrect.
If a calculated table is not the way to go, can i solve this via another measure? I need to count per store for how many products the score is above a certain value.
Thanks a lot for the help!