Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
jacccodezwart
Frequent Visitor

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,

jacccodezwart_0-1658391838813.png

but the properties in the model look like :

 

jacccodezwart_1-1658391894036.png

 

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 :

jacccodezwart_2-1658392101294.png

 

 

What did I mis ??

 

Thanks in advance.

 

Jacco

 

1 ACCEPTED SOLUTION
SpartaBI
Community Champion
Community Champion

@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).


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

View solution in original post

3 REPLIES 3
SpartaBI
Community Champion
Community Champion

@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).


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png


Full-Logo11.png

SpartaBI_3-1652115470761.png   SpartaBI_1-1652115142093.png   SpartaBI_2-1652115154505.png

Showcase Report – Contoso By SpartaBI

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

@jacccodezwart my pleasure 🙂
Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas and give it a thumbs up over there if you liked it 🙂
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.