Forum Discussion

LeeDubs's avatar
LeeDubs
New Member
3 years ago
Solved

Normalizing Data based on attribute AND selected "Product" selected from a slicer.

I have the below data.  I have unpivoted the data to have the columns Product, Attribute, Value.  Using the following  Normalized Value = VAR MinOfGroup = CALCULATE(MIN('Table'[Value]),ALLEXCEPT('T...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    LeeDubs , Try like

     

    Normalized Value =
    VAR MinOfGroup = CALCULATE(MIN('Table'[Value]),filter(allselected('Table'),'Table'[Attribute] = max('Table'[Attribute])))
    VAR MaxOfGroup = CALCULATE(MAX('Table'[Value]),filter(allselected('Table'),'Table'[Attribute] = max('Table'[Attribute])))
    VAR DetailValue = MAX('Table'[Value])
    RETURN DIVIDE(DetailValue - MinOfGroup,MaxOfGroup - MinOfGroup,0)

amitchandak's avatar
amitchandak
Super User
3 years ago

LeeDubs , Try like

 

Normalized Value =
VAR MinOfGroup = CALCULATE(MIN('Table'[Value]),filter(allselected('Table'),'Table'[Attribute] = max('Table'[Attribute])))
VAR MaxOfGroup = CALCULATE(MAX('Table'[Value]),filter(allselected('Table'),'Table'[Attribute] = max('Table'[Attribute])))
VAR DetailValue = MAX('Table'[Value])
RETURN DIVIDE(DetailValue - MinOfGroup,MaxOfGroup - MinOfGroup,0)

LeeDubs's avatar
LeeDubs
New Member
3 years ago

Wow.  Thank you so much.  This worked.  I have struggled and would have never gotten this.  Can you please breakdown and explain what the code in MinOfGroup (and MaxOfGroup) is doing?