Forum Discussion

jmorela1's avatar
jmorela1
Icon for Helper I rankHelper I
9 months ago
Solved

Calculation not working when slicers applied

I am trying to calculate a cost per Google form complete, but it does not calculate properly when BU or channel is selected. I have tried several different calculations/sums/measure, and cannot get t...
  • MFelix's avatar
    MFelix
    9 months ago

    Hi jmorela1 ,

     

    You must add a new measure that is the cost per google for or whatever other name you want to give it and di the division of both the measures you refere:

     

    Has you can see on my image the measure for the division between both of this values gives the correct value:

     

    In the file I have shared search for the measure Cost per google form and use it on the matrix you should get the correct value.

     



v-kpoloju-msft's avatar
v-kpoloju-msft
Icon for Community Support rankCommunity Support
9 months ago

Hi jmorela1,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to FBergamaschi, @ for his inputs on this thread.

Has your issue been resolved? If the response provided by the community member FBergamaschi,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

if it is not resolved, Could you please upload the .pbix file to OneDrive or Google drive and share the download link here? This will allow us to open the file, reproduce the issue, and verify the model and DAX behaviour accurately.
How to provide sample data: How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.