Forum Discussion

bbajuscak's avatar
bbajuscak
Icon for Helper I rankHelper I
1 year ago
Solved

Only display 1st occurrence in columns

I need help in displaying only the first occurence of a value for each column. 

 

I have 4 tables, each table is being used to populate a seperate column within the same visual.

Column 1 shows Initiatives

Column 2 shows Projects

Column 3 shows Epics

Column 4 shows Stories

 

Each initaive is made up of several Projects

Each Project is made up of several Epics

Each Epic is made up of several Stories

 

How do I display only the first row of initiative,

the first row for the project,

and the first row for the epics in this visual

 

Here is a screenshot of the visual to help get an idea what I am trying to accomplish

 

Greatly appreciate any insight on this!

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi bbajuscak ,

    Depending on your needs, I think you can try using Matrix visual.

    I create a table as an example.

    Then you can use matrix visual.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • bbajuscak's avatar
    bbajuscak
    Icon for Helper I rankHelper I
    1 year ago

    This is an excel mock up of what I am trying to achieve in my visual

     

  • girishthimmaiah's avatar
    girishthimmaiah
    Icon for Resolver I rankResolver I
    1 year ago

    Create measure For each column (Initiative, Project, and Epic), you can create a measure to show only the first occurrence.


    Measure for Initiative
    DAX

    First Initiative =
    VAR FirstRow = MINX(ALLSELECTED('Table'), 'Table'[Initiative])
    RETURN
    IF(SELECTEDVALUE('Table'[Initiative]) = FirstRow, SELECTEDVALUE('Table'[Initiative]), BLANK())

    Measure for Project
    DAX

    First Project =
    VAR FirstRow = MINX(FILTER(ALLSELECTED('Table'), 'Table'[Initiative] = SELECTEDVALUE('Table'[Initiative])), 'Table'[Project])
    RETURN
    IF(SELECTEDVALUE('Table'[Project]) = FirstRow, SELECTEDVALUE('Table'[Project]), BLANK())

    Measure for Epic
    DAX

    First Epic =
    VAR FirstRow = MINX(FILTER(ALLSELECTED('Table'), 'Table'[Project] = SELECTEDVALUE('Table'[Project])), 'Table'[Epic])
    RETURN
    IF(SELECTEDVALUE('Table'[Epic]) = FirstRow, SELECTEDVALUE('Table'[Epic]), BLANK())

    • bbajuscak's avatar
      bbajuscak
      Icon for Helper I rankHelper I
      1 year ago

      girishthimmaiah Thanks for the input on resolving this, I failed to mention that I have multiple Initiatives in the first column. I'd like to only show the 1st instance an Initiative is displayed. This resulted in only 1 Initiative displaying for the entire list of Initiatives.
      This is what I used for the new measure to receive this result:

      First Initiative =
      VAR FirstRow = MINX(ALLSELECTED('Initiatives - Issues'), 'Initiatives - Issues'[SUMMARY])
      RETURN
      IF(SELECTEDVALUE('Initiatives - Issues'[SUMMARY]) = FirstRow, SELECTEDVALUE('Initiatives - Issues'[SUMMARY]), BLANK())



      • bbajuscak's avatar
        bbajuscak
        Icon for Helper I rankHelper I
        1 year ago


        another look at what I am trying to clean up with this measure

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi bbajuscak ,

    Depending on your needs, I think you can try using Matrix visual.

    I create a table as an example.

    Then you can use matrix visual.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.