Forum Discussion
Solved
Conditional formatting Text count based as a % on the column total
Hi, Apologies for posting this but I am having issues with conditional formatting text, I have tried reading variuous threads but cannot get my head into gear. I have a text column called KRI...
SloeMo No, not because it is text because you have the Count aggregation. But, what you need to be using is the %GT of Count of KRI Category. Of course, you probably don't have that available in the conditional formatting stuff. But, you could create a measure like:
GT % Measure = VAR __Count = COUNT('Table'[Count of KRI Category) VAR __AllCount = COUNTX(ALL('Table'),[Count of KRI Category]) RETURN DIVIDE(__Count,__AllCount,0)
