Forum Discussion

hackfifi's avatar
hackfifi
Helper 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
Super 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
      Super 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
      Microsoft 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