Forum Discussion
Explicit Measure Not Working in Pivot Table in Analyze in Excel
I created a simple mesaure in Desktop, count(division). When I publish to the BI Service and then try to analyse in excel, the measure 'count' can not be placed in the report. I thought explicit measures could, understanding that implicit measure could not.
Anything else I should be doing to get this simple measure to work in analyse in excel for my end users?
I was able to get this to work as expected. For anyone wondering, I just changed the simple Measure Count into a more complex Measure using Summarize. Afterwards, the measure was available in excel.
1 Reply
I was able to get this to work as expected. For anyone wondering, I just changed the simple Measure Count into a more complex Measure using Summarize. Afterwards, the measure was available in excel.