Data type conversion from non aggregate to aggregate

[suman-kumar]

Hi Team,

I have created my Power BI account online where  I have imported Excel data.

There are some measures which should be measures but it is in dimesion means without Aggregate function. Here I have attached a screen shot.

Can you please help me to solve this issue.?

Thanks

Suman

[v-yuta-msft]

Hi suman-kumar，

Two things need to be checked:

1. There're no measures in your screenshot, please check if you have created measures in your excel file using power pivot.

2. No aggregation symbol means your data can't be aggregated, please check if your data type in your table can be aggregated(e.g.: number type)

Regards,

Jimmy Tao