Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculation

Hi,   I want to create a measure to get the smallest average taken from a list. Two screenshots below, show the data format and the visual I have taken.     I now want to use a meas...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago
    Hi Anonymous
     
    I took a look at your pbix and mistakenly thought you had calculated the average.
    You need to create a calculated column to calculate the average:

     

     

     

    average_col = CALCULATE(
                AVERAGE('Scores by check (2)'[Value]),
                FILTER(ALLSELECTED('Scores by check (2)'),
                        'Scores by check (2)'[Attribute]=EARLIER('Scores by check (2)'[Attribute])))

     

     

     

    Then create a measure to calculate the minimum average:

     

     

    Measure = MINX('Scores by check (2)','Scores by check (2)'[average_col])

     

     

     

     

    It works like this:
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
     
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

You could use "MINX" function to get the  minimum value in measure. Please try the DAX like this:

 

Measure = MINX(table,[AVG_value])

 

 

 

Best Regards,

Liang

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

Hi V-lianl-msft 

 

I have run this calculation however it just gives me the average of '1.6', instead of the lowest average by check

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    6 years ago
    Hi Anonymous,
     
    Measure is related to the current context, please note whether the data is filtered or use ALL function.

     

     

    Measure = MINX(ALL(table),[AVG_value])

     

     

    If the problem persists,could you please share sample data and DAX formula?

     

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

     

     

      • V-lianl-msft's avatar
        V-lianl-msft
        Icon for Community Support rankCommunity Support
        6 years ago
        Hi Anonymous
         
        I took a look at your pbix and mistakenly thought you had calculated the average.
        You need to create a calculated column to calculate the average:

         

         

         

        average_col = CALCULATE(
                AVERAGE('Scores by check (2)'[Value]),
                FILTER(ALLSELECTED('Scores by check (2)'),
                        'Scores by check (2)'[Attribute]=EARLIER('Scores by check (2)'[Attribute])))

         

         

         

        Then create a measure to calculate the minimum average:

         

         

        Measure = MINX('Scores by check (2)','Scores by check (2)'[average_col])

         

         

         

         

        It works like this:
         
        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.