Dax Row Level Normalization/ Conditional Formatting Help

[mutaharbhatti]

I want help to create 1 measure which can do both work so I can put it on the table and be able to drill up and drill down 

Hi, 

I have 2 Dax Measures which normalize the data between 0 to 1 so I can use them to create row-based conditional formatting.

1st Measure normalizes the data for only  Year and 2nd one normalizes data for only Quarters

I am attaching a .pbix file you can go through it to see my dax measures 

Thanks

Power Bi File 

https://www.dropbox.com/s/6lca1mcelm301tu/Power%20Bi%20Help.pbix?dl=0

DAX Measure Used for Normalizing Quaterly  just Removed Quater from summary table and from allselected() to create yearly

Value Graient =

VAR summarytable = 

CALCULATETABLE(

ADDCOLUMNS( 

SUMMARIZE(Vol,

Vol[Product],Vol[Year],Vol[Quater]

),"values",[Values]),

ALLSELECTED(Vol[Year],Vol[quater])

)

Var MaxValue =

MAXX(summarytable,[values])

Var MinValue =

MINX(summarytable,[values])

VAR Range = MaxValue - MinValue

Var Hue =

ROUND(

DIVIDE([Values] - MinValue,

Range),2)

Return

Hue