Forum Discussion

xcrmadmin's avatar
xcrmadmin
Helper I
3 years ago

Condition formation per month column

Dear Experts I Am try to format each coulmn in power bi matrix based on the max to min value as gradient color. I did my best and the result not coming as expected. My matrix inlcude monthes and per...
Need Help
Show and Tell
Tips and Tricks
xcrmadmin's avatar
xcrmadmin
Helper I
3 years ago

this my measure but the result not as expected, and i use this measure to coloring the matrix per month name column.

 

CALCULATE ( SUM ( DIM_WON_ANALYTICS[Actual Revenue] ), ALLEXCEPT ('Date', 'Date'[UNMMAE] ) ) IF ( HASONEVALUE ( 'Date'[UNMMAE] ), CALCULATE ( SUM ( DIM_WON_ANALYTICS[Actual Revenue] ) ), MAXX ( ALLEXCEPT ( 'Date', 'Date'[UNMMAE] ), CALCULATE ( SUM ( DIM_WON_ANALYTICS[Actual Revenue] ) ) ) )
xcrmadmin's avatar
xcrmadmin
Helper I
3 years ago

Then i used below meassure but alos the result not as expected 

 

SUMX ( FILTER ( ALL ( 'Date' ), 'Date'[UNMMAE] = SELECTEDVALUE ( 'Date'[UNMMAE] ) ), [Total Sales] )