Numeric Data Column Cannot Be used as "Values" field in Matrix Table Visual

Hi Anonymous 

If numeric values can't be dragged into the Values field well, it appears that "Discourage implicit measures" is turned on for this model.

See here:

https://learn.microsoft.com/en-us/power-bi/transform-model/model-explorer#discourage-implicit-measures

This setting could have either been turned on:

1. Automatically if a calculation group has ever been added to the model.
2. Manually if someone switched this on.

You won't be able to turn this setting off unless the model contains no calculation groups.

If you need to keep calculation groups in the model, then you could use a script like this one in Tabular Editor to create measures aggregating each required column:

https://docs.tabulareditor.com/te2/Useful-script-snippets.html#create-measures-from-columns

Regards