Forum Discussion

nmhung49's avatar
nmhung49
Icon for Helper II rankHelper II
1 year ago
Solved

How to create measure to CALCULATE Qty_In

I’m having trouble with the CALCULATE function for Qty_In, which is incorrect when I select the current year and month. I want the result to display the farm org for the selected month and year, and ...
Need Help
  • hnguy71's avatar
    hnguy71
    1 year ago

    Hi nmhung49 

    You can test if there's a qty, then calculate where document type is 65. You can try this measure:

    IF.EAGER( SUM(factBreeder[QTY]) > 0, CALCULATE( SUM(factBreeder[QTY]), KEEPFILTERS(factBreeder[DOCUMENT_TYPE]   = 65), ALL('Calendar') ) )
nmhung49's avatar
nmhung49
Icon for Helper II rankHelper II
1 year ago

Sorry, if I add the Farm level into the matrix, the sum by farm is incorrect. Please help me edit the DAX again. Thanks!

 

  • hnguy71's avatar
    hnguy71
    Icon for Super User rankSuper User
    1 year ago

    hi nmhung49 

    Can you share a sample of the expected value / output when you add the farm?

      • hnguy71's avatar
        hnguy71
        Icon for Super User rankSuper User
        1 year ago

        Hi nmhung49 ,

        There are times when you apply a filter criteria within your expression you would still receive the cumulative total even though at the line item is correct. To fix this, you would create a new measure to sum on top of that sum. For your example, create a new measure and replace the measure in your visual with this one:

        Corrected.InQty = SUMX(dimFarmOrg, [Qty_InV1])