Forum Discussion

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi TienNog ,

       

      I suggest you to create a measure to filter your visual.

      Filter = 
VAR _SELECTION =
    SELECTEDVALUE ( DimAccountShort[AccountShort] )
VAR _JournalCombine =
    CALCULATE (
        MAX ( 'Table'[JournalCombine] ),
        FILTER ( ALL ( 'Table' ), 'Table'[AccountShort] = _SELECTION )
    )
RETURN
    IF (
        AND (
            MAX ( 'Table'[JournalCombine] ) = _JournalCombine,
            MAX ( 'Table'[AccountShort] ) <> _SELECTION
        ),
        1,
        0
    )

      Add this measure into visual level filter and set it to show items when value = 1.

       

      Best Regards,

      Rico Zhou

       

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

      • TienNog's avatar
        TienNog
        Frequent Visitor
        2 years ago

        Dear Anonymous , thank you for your solution, but unfortunately it still doesn't work as my expectation. the result that I want report to show as screenshot. I tried a few adjustments to the measure but the results were not as expected. I would appreciate if you could review my expectation results as below. Thank you in advance. 

  • TienNog's avatar
    TienNog
    Frequent Visitor
    2 years ago

    Who can help me this matter? I can not find out any solutions for this.