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') ) )
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])