Forum Discussion
Condditional formating based on another table
Hi
I would like to make visible in the table # 1 with sale per emplyee when they were eligible for bonus.
The bonus is based on other criteria than sale and it is showing displayed in the table #2. so the table #2 is the source of the conditions that should aply to the table #1
and this is how the end result should look like it can be also different font color
thank you
3 Replies
hi Anonymous
Thank you for your qick response. I was affraid that woudl be the case.
Isnt there a way how to do this with help of DAX.
Lets say i have the total sale data in a different table where i would need to calculate it first
- something like
john sale = calculate (sum(table all sale,table all sale[2015]),filter(tabletable all sale[employee]="john")
and then
= if(table#2[2015]="Bonus", format("john sale", "red", text), "john sale"
i mean this is very simplistic but i am still very new to dax .. but you might get the idea and maybe you can help
thank you