Forum Discussion

Dellis81's avatar
Dellis81
Post Prodigy
3 years ago

Paginated report

Hello Friends!

 

I am attempting to convert a few PBI visuals to paginated reports - with one of those being an income statement.  Unfortunately what works inside a visual matrix does not work within a paginated matrix.   As I have dug into the various measures, I suspect this measure is my problem.

ScopeCurrentLevel = 
VAR level4 =
    IF ( ISINSCOPE ( FinStatementTemplates[Level 4] ), 4 )
VAR level3 =
    IF ( ISINSCOPE ( FinStatementTemplates[Level 3] ), 3 )
VAR level2 =
    IF ( ISINSCOPE ( FinStatementTemplates[Level 2] ), 2 )
VAR level1 =
    IF ( ISINSCOPE ( FinStatementTemplates[Level 1] ), 1 )
VAR level0 =
    IF ( ISINSCOPE ( FinStatementTemplates[Level 0] ), 0 )    
VAR levelT =
    IF ( ISINSCOPE ( FinStatementTemplates[Level -1] ), -1 )    
RETURN
    COALESCE ( level4, level3, level2, level1, level0, levelT )

 

As you can see in the below image - this measure is returning differing results for the top hiearchy levels.   Level 0 would equate to "Cost of Sales"   Within paginated, I have the exprssion aggregation set to "min"

 

Are there thoughts on how this measure might be tweaked so the paginated report would be equivalent.   Or guidance in better understanding what the problem might be?

 

Need Help

2 Replies

    • Dellis81's avatar
      Dellis81
      Post Prodigy
      3 years ago

      Thank you Sir!

      Watched your video several times, and made the change to a switch statement.   However the result is the same.   I am confident the PBI matrix visual is working as expected, it's taking the same measure to Paginated reporting is the problem.

      Any other thoughts or videos that I can pursue?

       

      thank you!