Forum Discussion

MScholten's avatar
MScholten
New Member
7 years ago

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!

 

1 Reply

  • Mariusz's avatar
    Mariusz
    Community Champion

    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.
    Mariusz Repczynski