Clustered Column Visual

I have the following visual which uses filter It is set less than 4

Top 3 by frequency =

IF (

ISBLANK ( [Count of Total Gross Incurred] ),

BLANK (),

RANKX ( ALL ( InjuryCause[Cause Grouping] ), [Ref],, DESC, SKIP ))

and also uses measure Top N where Top is 3

Sort measure Count Tenure Cause =

VAR _FreqByPolicyYear = CALCULATE([Count of Total Gross Incurred], FILTER(ALL(InjuryCause[Cause Grouping]), [Top 3 by frequency]<4))

VAR _LN = LEN(FORMAT(CALCULATE([Count of Total Gross Incurred], ALL('LossRun'[LOE 2023])), "text"))

VAR _Pre = _FreqByPolicyYear *POWER(10, _LN*2)

VAR _Inc = CALCULATE(RANKX(ALLSELECTED(LossRun[LOE 2023]), [Count of Total Gross Incurred],,ASC,Dense), ALLSELECTED(InjuryCause[Cause Grouping]))

VAR _Mid = _Inc * POWER(10, _LN)

RETURN

IF(ISBLANK([Count of Total Gross Incurred]), BLANK(), _Pre + _Mid + RANKX(ALLSELECTED(InjuryCause[Cause Grouping]),[Ref],,ASC,Skip))

How do I eliminate the blank column showing for 1 yr.?

I assume because it leaves space for the Strain Blue column the others have ones have but for 1 yr, strain is not in top 3.

bdehning
2 years ago
I solved the issue by adding both Cause and LOE to my X-Axis.

Forum Discussion