Forum Discussion

bdehning's avatar
bdehning
Post Prodigy
2 years ago
Solved

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[Ca...
Need Help
  • bdehning's avatar
    bdehning
    2 years ago

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

bdehning's avatar
bdehning
Post Prodigy
2 years ago

Hard to share file, which part did you modify with your Rank=?  Was it the Top 3 By Frequency or the Sort Measure?   

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • bdehning's avatar
    bdehning
    Post Prodigy
    2 years ago

    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]?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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?

      • bdehning's avatar
        bdehning
        Post Prodigy
        2 years ago
        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)