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 hackfifi,

 

Here is the calculated field formula i wrote for Quantity

 

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

Hope this helps.