Forum Discussion
Clustered Column Visual
I solved the issue by adding both Cause and LOE to my X-Axis.
Hi bdehning ,
I think we should change it here.
Assuming that the column 'Cause Grouping' has the values 'No Data','<1yr','yr', and you have cleared the filtering capability of the field using the ALL function, the 'Ref values should all be the same, for sorting all are 1
I was trying this earlier and trying to figure out What is Sheet1 and Sheet1[Type] and then Col2. I Assume Sheet1 is Injury Cause and Type is Cause Grouping. Not sure what Col2 is for me? Its Either Count of Total Gross Incurred or LossRun[LOE 2023]?
Sorry for the confusion. These are my hypothetical data, 'Sheet1' is 'InjuryCause', 'Type' is 'Cause Grouping', and 'col2' is the value of 'Ref'. Can you share some simple data?
- Here is what I am trying but when I use EARLIER('InjuryCause'[Cause Grouping])) 'InjuryCause'[CauseGrouping] is in red? Is not not like EARLIER? Refers to an earlier row context which doesn't exist?Top 3 by frequency =IF (ISBLANK ( [Count of Total Gross Incurred] ),BLANK (),RANKX (FILTER('InjuryCause', 'InjuryCause'[Cause Grouping] = EARLIER('InjuryCause'[Cause Grouping])),LossRun[Count of Total Gross Incurred],,DESC,Skip)
Hi bdehning ,
This function requires a row-context computing environment .Please attempts to create a calculated column, not a measure.