Forum Discussion

hackfifi's avatar
hackfifi
Icon for Helper V rankHelper V
8 years ago
Solved

Drill Level Matrix - Calculation Query

  Is there a way to control the CALCULATION in Matrix based on Drill Level?   In my DATA table, i have column "Quantity".  When using the MATRIX Visual, the Column "Quantity" & "Hours" is Summed u...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi hackfifi,

     

    Here is the calculated field formula i wrote for Quantity

     

    =if(HASONEVALUE(Table3[Type]),SUM([Quantity]),BLANK())

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

This should be doable,  Please share the link from where i can download your Excel/PowerBI desktop file.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi hackfifi,

     

    Here is the calculated field formula i wrote for Quantity

     

    =if(HASONEVALUE(Table3[Type]),SUM([Quantity]),BLANK())

    Hope this helps.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi hackfifi,

     

    Have you tried the solution provided by Ashish_Mathur above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards