Forum Discussion
Unable to use numeric column from SSAS Tabular Model as value
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).
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).
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