locked
Display Correct Data i Tabular RRS feed

  • Question

  • Goal:
    Filtrate data from a existing table in Tabular mode in SSAS
    The table's result is to display "a" only in the column test2:

    table name ttt

    test    test2    test3
    -----------------------
    1        a       x
    2        a       6

    Problem:
    How should I do it after I have retrieved the data in SSAS tabular? The retrieve of the data is below? How should I write the DAX code?

    table name ttt

    test    test2    test3
    -----------------------
    1        a       x
    2        a       6
    4        b       x
    3        b       t
    ..
    ..
    etc about 3 milion row

    Info:

    In this case, T-SQL should not be used.

    • Edited by Sakura Data Thursday, May 23, 2013 4:52 PM About T-SQL
    Monday, May 20, 2013 11:31 AM

Answers

  • Hey Sakura,

    I don't know if I got your question right, but from my understanding you want to filter all your data to "a" in column "test2".

    You can do this by only loading the corresponding data (using t-sql (SELECT * from WHERE [test2] = 'a')). Therefore you need to click table-properties and paste your  t-sql there.

    I hope I could help.

    Pls mark helpful posts! Thanks

    Thursday, May 23, 2013 9:21 AM