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

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)
    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi bdehning ,

      This function requires a row-context computing environment .Please attempts to create a calculated column, not a measure.

      • bdehning's avatar
        bdehning
        Post Prodigy
        2 years ago

        I tried to use 'InjuryCause'[Cause Grouping] after EARLIER and it stays red.   Is not 'Sheet1'[Type] not the same on both sides of the =?