Forum Discussion

icdns's avatar
icdns
Post Patron
4 years ago
Solved

Computation per Unit

Hi Guys, 

 

Would need your help in computing the per unit computation. I have year my monthly table. The computation of PER UNIT is Data Point per Month / Maximum Data Point. Ex. 456/999 to get 0.46. 

 

I tried Max function but it doesnt get the max value for the month. Could somebody help me? 

 

 

Thank you! 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi icdns ,

    Please refer to my pbix file to see fi it helps you.

    Create a measure or column.

     

     

    Measure =
VAR max_value =
    CALCULATE (
        MAX ( sampledata[Sales] ),
        ALLEXCEPT ( sampledata, sampledata[Year] )
    )
RETURN
    DIVIDE ( MAX ( sampledata[Sales] ), max_value )

     

     

    The column.

     

     

    Column =
VAR max_value =
    MAX ( sampledata[Sales] )
RETURN
    DIVIDE ( sampledata[Sales], max_value )

     

     

    If I have misunderstood your meaning, please provide your desired output with more details.

     

     

    Best Regards

    Community Support Team _ Polly

     

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

     

6 Replies

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    HI icdns 

     

    You need to calculate the MAX when you removed the filter to consider all rows' values.

    Try this to find 999:

     

    MAX Value = calculate(MAX(Table[Count]),all(table))

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
    Appreciate your Kudos!!
    LinkedIn:     www.linkedin.com/in/vahid-dm/

     

     

    • icdns's avatar
      icdns
      Post Patron
      4 years ago

      Hi VahidDM ,

       

      My report has filters like YEAR etc, how can go about it? Like it will be dynamic depending on your filters..

      It will compute the PER UNIT. 

       

      Thanks alot!! 

      • VahidDM's avatar
        VahidDM
        Super User
        4 years ago

        icdns 

         

        In that case, you need to use removefter Dax formula or you can define a variable and find the max with my previous formula and use allexcept(table,table[year]).

         

        can you share a sample of your data or your PBIX file.

         

        If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
        Appreciate your Kudos!!
        LinkedIn:         www.linkedin.com/in/vahid-dm/

         

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi icdns ,

    Please refer to my pbix file to see fi it helps you.

    Create a measure or column.

     

     

    Measure =
VAR max_value =
    CALCULATE (
        MAX ( sampledata[Sales] ),
        ALLEXCEPT ( sampledata, sampledata[Year] )
    )
RETURN
    DIVIDE ( MAX ( sampledata[Sales] ), max_value )

     

     

    The column.

     

     

    Column =
VAR max_value =
    MAX ( sampledata[Sales] )
RETURN
    DIVIDE ( sampledata[Sales], max_value )

     

     

    If I have misunderstood your meaning, please provide your desired output with more details.

     

     

    Best Regards

    Community Support Team _ Polly

     

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