Forum Discussion
Value disapearing when using YTD measure on Matrix visualization
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.
Community ChampionIt'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.
Thank you, the problem was a filter. As soon as I did your solution I found out the issue.
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])RETURNSWITCH(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:Thank you for your answer.BS_SummaryItems =VAR SummaryItem = SELECTEDVALUE('Transactions_Groups'[longname])RETURNSWITCH(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])
