Forum Discussion
Conditional formatting Text count based as a % on the column total
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)
thanks Greg_Deckler
I had tried that previously based on other threads but these are the results.
Am I doing something wrong in the format, it looks like as I am using number as a rule nothing actually falls into the rule parameter as the actual lowest count in the data is 2. I need it work from a % as the numbers will change.
Didn't know if this is because the column is text?
Thanks
Lee
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)