Forum Discussion

Kiwi_911's avatar
Kiwi_911
New Member
4 months ago
Solved

CubeValue formula to data model - only works partially

Hello, I created a simple comparison file using Power Query and Cubevalue formulas. In the background, files are read from folders and compiled into an overview called 'Periodenvergleich' I have lo...
Need Help
  • pcoley's avatar
    pcoley
    4 months ago

    Kiwi_911 
    The actual formula has an IFERROR surrounding the CUBEVALUE formula; it returns 0 if the CUBEVALUE formula evaluation returns an error.
    Therefore, in the report the 0-values might correspond to errors in the CUBEVALUE calculations.
    Please try evaluating it without the IFERROR and try to debug if there are errors; please check if you have in Measures the corresponding formulas for each Organizational Unit (and that they work with the "Summe von "&OrganizationUnitName).
    If this does not work please share the formulas you have in [Measures] so we can try to find if there are some issues there.

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
4 months ago

Thankyou, pcoley for your response.

Hi Kiwi_911,

 

We are pleased to note that your issue has been resolved. Thank you for sharing your insights and approach in resolving the issue, which will be beneficial to other members of the community. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

 

Thank you.