Can't use numeric field as value in visualisation powerbi

[Anonymous]

1.

2.

I have been working on a dashboard and its fetching the data from excel(sharepoint; live sheet) and suddenly i cant create a report/visualisation as it suddenly stopped considereing numerical data as numerical, if it makes sense, as you can see in the 1st screenshot, its the same data in screenshot 2 and its taking numerical data as it should be .

I am not sure what went wrong, i have already checked the connection, data type everything is okay.

let me give an example to give better understanding. i have no. of tests column as in the screenshot 1; i have choosen card visualisation and it wont let me take the number of tests column but if i take table and then number of tests column it will take it and then i change the visualistion to card, it will work then.

It stopped working all of the sudden.

[MFelix]

Hi @Anonymous ,

Have you added any calculation Groups to your model?

The usage of calculated Groups will turn of the option to use implicit measures on your visuals and you need to create explicit measures for all your calculations.