Creat general ledger details by using PBI

[TienNog]

Hi friends,

I am learning PBI and going to create general ledger detail by using power BI. I send template data here, I am very appreciate if anyone can help to give me a solution. Thank you very much.

https://docs.google.com/spreadsheets/d/151ZhnrwkdDw48_rCLhjtuAr8Tqt1SY-Q/edit?usp=drive_link&ouid=11...

[TienNog]

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

[TienNog]

anyone can help me the solution?

[Anonymous]

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]

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.