Forum Discussion
homboy27
Helper III
Helper IIIConditional Formula and Formatting based on a value in colum
I have the below column. I would like to highlight any client that has a senior manager and manager level. So for example I would like to highlight client A and C since both of them have a senior man...
Thank you, please see below. If I click on East, total sales for East is $5k (Left pic) and there are 2 employees so the average for east would be 2.5k, not 1k. Do you know how to update for that?
Hi homboy27
AvgSalesPerEmployeeRegion = AVERAGEX( SUMMARIZE( 'Table', 'Table'[Region], 'Table'[Employee Name], "AvgSales", SUM('Table'[Sales]) ), [AvgSales] )Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jihwan_Kim
Super User
Super UserHi,
I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
color condition: =
VAR _t =
FILTER (
CALCULATETABLE (
SUMMARIZE ( Data, 'Level'[Level] ),
ALL ( 'Level'[Level], 'Level'[sort_order] )
),
'Level'[Level] IN { "Senior Manager", "Manager" }
)
RETURN
IF ( COUNTROWS ( _t ) >= 2, "yellow" )