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....
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.

     

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/