Forum Discussion

dti's avatar
dti
Frequent Visitor
9 years ago
Solved

Power Bi Service Measures

I am creating a report in Power BI desktop and using various measures. All measures work appropriately on desktop. An example of one of the measures is shown below. It is a direct query to SQL server...
Need Help
  • dti's avatar
    dti
    9 years ago

    I was formatting a column in Direct Query as a decimal number. When I used this column in a slicer, it would cause my measures to stop working in the Power BI Service. Once I changed the column to type 'any', the measures worked. So yes, the problem was solved by changing the column type to 'any' from decimal number.

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

dti

 

It is good news that you’ve got it resolved. But it’s really strange, I also tried to add a decimal number column in my database and used it in a slicer. My measure is still working in the Power BI Service.

 

Best Regards,

Herbert

JDSX's avatar
JDSX
Frequent Visitor
9 years ago

Hi,

 

My problem is somewhat similar but not enough that I could solve it same way. I added a measure which works in a KPI on desktop but not in cloud because it doesn't sync to the dataset. Measure is defined as:

 

Active Companies = COUNTAX('Company', 'Company'[is_active] = TRUE())

 

The error text is:

 

Fields that need to be fixed
 
Something's wrong with one or more fields: (Company) Active Companies
Please try again later or contact support. If you contact support, please provide these details.

 

Activity IDe83e5d04-9dfc-5bc0-52be-f69d33fe30da
TimeSat Dec 17 2016 21:09:33 GMT-0500 (Eastern Standard Time)
Correlation ID94d5f48a-4013-994e-e78c-61e1d7cbcd41
Version13.0.1700.811
Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net