Forum Discussion

TienNog's avatar
TienNog
Frequent Visitor
2 years ago

Creat general ledger details by using PBI

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 mu...
Need Help
TienNog's avatar
TienNog
Frequent Visitor
2 years ago

anyone can help me the solution?

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.