Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
I am working on a power BI report using Analysis Services as my data source ( Jet OLAP cubes).
One of my measures is giving me an error in Power BI but works perfectly in Excel!
#ERROR! The Axis function was indirectly referenced from the context of a statement other than SELECT. Evaluation of expressions involving this function succeed only when indirectly triggered by a SELECT statement.
The measure is calculating % of column total and I am using it in a Matrix, the same way I am using it in a pivot table in Excel, where it works!!
Does anyone have any ideas how to make this work?
Thanks a lot
Monica
Solved! Go to Solution.
Hi @monicatanasescu ,
Based on the error message, it seems that your measure contains MDX function Axis function .
As power bi is only supported for DAX, so the measure with MDX will not work in power bi. You'd better create the measure with Dax in SSAS.
Best Regards,
Cherry
Hi @monicatanasescu ,
Based on the error message, it seems that your measure contains MDX function Axis function .
As power bi is only supported for DAX, so the measure with MDX will not work in power bi. You'd better create the measure with Dax in SSAS.
Best Regards,
Cherry
Hello, what you do if the source is an OLAP cube and not tabular
Makes sense! Thanks a lot
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |