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.

dti's avatar
dti
Frequent Visitor
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