Forum Discussion

Solfieri's avatar
Solfieri
Frequent Visitor
2 years ago
Solved

Value disapearing when using YTD measure on Matrix visualization

Problem Description: I am experiencing an issue with a Year-To-Date (YTD) measure in Power BI. When I insert this YTD measure into a matrix visualization, the Net Income value disappears. However, wh...
Need Help
  • MattAllington's avatar
    MattAllington
    2 years ago

    It's not clear if the measure in these 2 matrix is the same. I will assume so. The existence, or not, of a second measure in a matrix cannot affect the first measure, so that is not the cause. It seems the columns in rows in both matrixes are different. This is the likely cause. I suggest you create a new blank page, add 2 matrixes containing the measure in question, then build both matrixes. Watch carefully to see what works and what causes it not to work. Then investigate what stops it working. 

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
2 years ago

It's not clear if the measure in these 2 matrix is the same. I will assume so. The existence, or not, of a second measure in a matrix cannot affect the first measure, so that is not the cause. It seems the columns in rows in both matrixes are different. This is the likely cause. I suggest you create a new blank page, add 2 matrixes containing the measure in question, then build both matrixes. Watch carefully to see what works and what causes it not to work. Then investigate what stops it working. 

Solfieri's avatar
Solfieri
Frequent Visitor
2 years ago

Hello, 
They aren't the same measure, but both measures have a similar structure as I show bellow:
1) The one that's working on income statement, and showing the right, value is built with this summary structure:

All_SummaryItems =
VAR SummaryItem = SELECTEDVALUE('Income Statement Names'[longname])
RETURN
SWITCH(TRUE(),
SummaryItem = "Income", [Revenue],
SummaryItem = "Margin Percent [%]", [Margin_Percent],
SummaryItem = "Cost of Goods Sold",[CostofGoodsSold],
SummaryItem = "Total Revenue", [Revenue],
SummaryItem = "Gross Profit", [calc_GrossProfit],
SummaryItem = "Expense", [Expense],
SummaryItem = "Operating Income", [calc_OperatingIncome],
SummaryItem = "Other Income", [OtherIncome],
SummaryItem = "EBITDA", [i_EBITDA],
SummaryItem = "Net Income", [YTDNetIncome])

2) The one that doesn't accept the YTD measure use this struture:
BS_SummaryItems =
VAR SummaryItem = SELECTEDVALUE('Transactions_Groups'[longname])
RETURN
SWITCH(TRUE(),
SummaryItem = "Bank", [Bank],
SummaryItem = "Accounts Receivable", [Accounts Receivable],
SummaryItem = "Other Current Asset", [Other Current Asset],
SummaryItem = "Other Asset", [Other Asset],
SummaryItem = "Fixed Asset", [Fixed Assets],
SummaryItem = "Accounts Payable", [Accounts Payable],
SummaryItem = "Credit Card", [Credit Card],
SummaryItem = "Other Current Liability", [Other Current Liabilities],
SummaryItem = "Long Term Liability", [Long Term Liabilities],
SummaryItem = "Equity", [Equity],
SummaryItem = "Net Income", [NetIncome]
)

3) But doing as you suggested I tried a new structure to see the results and I made a simple sum of the values in the Balance Sheet, also using a dimension table with no direct relationship with the values table, and as soon as I insert a YTD measure, the net income row disappear:
TotalBalanceSheet = CALCULATE([Total Current Assets] + [Fixed Assets] + [Other Asset] + [Total Current Liabilities] + [Equity] + [YTDNetIncome] + [Long Term Liabilities])
Thank you for your answer.