Store result from table visual as calculated table

[MScholten]

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!

[Mariusz]

Hi @MScholten 

You can use Query Editor to create your table, please can you provide a data sample and your Dax Measure syntac for Score

Best Regards,
Mariusz

Please feel free to connect with me.