Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Measure totals do not return expected values

Hi All,   I've a simple measure with 2 variables that calculate the sum/difference of columns from multiple tables and result is set to return min of these 2 variables, It displyed correctly in the...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on your description, I created data to reproduce your scenario.

     

    You may create three measures as follows.

    AB = SUM('Table'[A])+SUM('Table'[B])

CD = SUM('Table'[C])+SUM('Table'[D])

MinResult = 
SUMX(
    'Table',
    CALCULATE(MIN([AB],[CD]))
)

     

    Result:

     

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I'll try to explain the issue better this time

     

    I've a measure to return min of two variables. So, let's say for a given country, i have 2 entries, 1 for each state as below. As expected, measure returns the min values for each state (see below). Now, when i show the total value for column - 'Min value' it is showing 5 instead i.e., it is adding the values for B (5) and comparing it with A (6) and returning the minimum value of the total

     

    ABStateCountryMin value of A,B 
    12TxUS1 
    53CaUS3 
       Total5 

     

     

     

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Try like

      sumx(summarize(table,table[state],table[country], "_min",min(table[A],table[B])),[_min])

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        It is not working.. i tried with sample data and returns the following error