Forum Discussion

nickvb's avatar
nickvb
Frequent Visitor
5 years ago

Values Not Displaying in Matrix

I am trying to create a monthly balance sheet, but the matrix visual is not displaying values in some periods.   As you can see in the below snapshot the total for Non-Current Liabilities does not ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

nickvb , This formula need one change. try that if that can work

 

BS Current YTD =
IF (
HASONEVALUE ( 'GL Balance'[ACCOUNTING_YEAR_KEY] ),
CALCULATE (
[CY],
FILTER (
ALL( 'GL Balance'[ACCOUNTING_YEAR_KEY] ),
'GL Balance'[ACCOUNTING_YEAR_KEY] in VALUES ('GL Balance'[ACCOUNTING_YEAR_KEY] )),
FILTER (
ALL( Date_Table[IFS Period] ),
Date_Table[IFS Period] <= MAX (Date_Table[IFS Period] )
)
),
BLANK ()
) *-1

nickvb's avatar
nickvb
Frequent Visitor
5 years ago

amitchandak thanks for the response.  I tried your formula, but unfortunately it is yielding the same result

  • nickvb's avatar
    nickvb
    Frequent Visitor
    5 years ago

    One other nuance I noticed.  It appears as long as there is no change in the next period it is showing up blank. However, if the value changes in the next period then it will re-appear and display correctly.

     

    • amitchandak's avatar
      amitchandak
      Super User
      5 years ago

      nickvb , Also check the role of HASONEVALUE, is working as expected. Remove that if part and try