Forum Discussion

jacccodezwart's avatar
jacccodezwart
Helper I
4 years ago
Solved

Unable to use numeric column from SSAS Tabular Model as value

Hi there,

 

I have a SSAS tabular model (compatibility level SQL Server 2019 / Azure Analysis Services (1500)) and this model is deployed to SSAS server (version 15.0.35.19). The data is retrieve from MS SQL Server.

 

When connecting to this model using Live Connect from Power BI (Version: 2.100.1381.0 64-bit ) I can import the model. Whitin the model all the columns of the numeric type can't be used as a value to present in a graph or do calculations with.

 

There is no sigma sign in front of the column name,

but the properties in the model look like :

 

 

so by default this column should be able to at least summerize.

 

The data is retrieve from MS SQL Server database via views. When looking at this view, the column is numeric :

 

 

What did I mis ??

 

Thanks in advance.

 

Jacco

 

Need Help
Tips and Tricks
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    jacccodezwart probably someone created a Calculation Group on this model. 
    This will force the mode property 'Discourage Implicit Measure' to True
    And you will not be able to use implicit aggregations rather explicitly create measures on top of the columns (which is anyway the best practice)
    You can undo this change by changing this model propery but only if you first delete all the calculation groups (in case you don't need them).





          

    Showcase Report – Contoso By SpartaBI

3 Replies

  • SpartaBI's avatar
    SpartaBI
    Community Champion
    4 years ago

    jacccodezwart probably someone created a Calculation Group on this model. 
    This will force the mode property 'Discourage Implicit Measure' to True
    And you will not be able to use implicit aggregations rather explicitly create measures on top of the columns (which is anyway the best practice)
    You can undo this change by changing this model propery but only if you first delete all the calculation groups (in case you don't need them).





          

    Showcase Report – Contoso By SpartaBI

    • jacccodezwart's avatar
      jacccodezwart
      Helper I
      4 years ago

      SpartaBI, super thanks !!!!

       

      Took a while to find the property, but after switching to code and search for the property, turn it to false, deploy the model, everything works !!!!

       

      I know that using measures on top of columns is the best practice, but during development of the model I like to experiment using the columns direct.

       

      Thanks again !!

       

      Jacco