Hi All,
how to display the numerator and denominator value only when we drill down in the matrix visual and not to display All time??
| Display | year and ratio |
| Current Ratio | | 1.21 |
| Current Assets | 1214 | |
| Current Liabilities | 1003 | |
| Debt-Equity Ratio | | 1.42 |
| Borrowings | 383 | |
| Total Equity | 269 | |
calculation i have created below
Billing Axis Table =
ADDCOLUMNS(
GENERATESERIES(1, 8),
"SortID", [Value],
"Display", SWITCH([Value], 1, "Current Ratio", 2, "Debt-Equity Ratio", 3, "Return on Equity Ratio (%)", 4, "Inventory turnover ratio", 5, "Trade Receivables turnover ratio", 6, "Trade Payables turnover ratio", 7, "Net capital turnover ratio", 8, "Net profit ratio (%)"),
"Numerator", SWITCH([Value], 1, "Current Assets", 2, "Borrowings", 3, "PAT", 4, "COGS", 5, "Revenue from Operations", 6, "Purchases", 7, "Revenue from Operations", 8, "PAT"),
"Denominator", SWITCH([Value], 1, "Current Liabilities", 2, "Total Equity", 3, "Average Shareholders equity [(Opening + Closing)/2]", 4, "Average Inventories [(Opening + Closing)/2]", 5, "Average Receivables [(Opening + Closing)/2]", 6, "Average Payables [(Opening + Closing)/2]", 7, "Working Capital (Current Assets - Current Liabilities)", 8, "Revenue from Operations"
))
measures --
Numerator =
IF(
HASONEVALUE('Master_Year'[Year]), // Replace with your actual date hierarchy column
VAR SelectedDisplay = SELECTEDVALUE('Billing Axis Table'[Numerator])
VAR assets = [Current Assets]
VAR Borrowing = [Borrowings]
VAR PAT1 = [PAT]
VAR COGS = [COGS]
VAR RevenuefromOperations1 = [Revenue from Operations]
VAR Purchases = [Purchases]
VAR RevenuefromOperations2 = [Revenue from Operations]
VAR PAT2 = [PAT]
RETURN
SWITCH (
TRUE(),
SelectedDisplay = "Current Assets", assets,
SelectedDisplay = "Borrowings", Borrowing,
SelectedDisplay = "PAT", PAT1,
SelectedDisplay = "COGS", COGS,
SelectedDisplay = "Revenue from Operations", RevenuefromOperations1,
SelectedDisplay = "Purchases", Purchases,
SelectedDisplay = "Revenue from Operations", RevenuefromOperations2,
SelectedDisplay = "PAT", PAT2
),
BLANK() // Return blank for "All" time period
)
Denominator =
IF(
HASONEVALUE(Master_Year[Year]),
VAR SelectedDisplay = SELECTEDVALUE('Billing Axis Table'[Denominator])
VAR Liabilities = [Current Liabilities]
VAR TotalEquity = [Total Equity]
VAR AverageShareholdersequity = [Average_Shareholders_Equity]
VAR AverageInventories = [Average_Inventories]
VAR AverageReceivables = [Average_Receivables]
VAR AveragePayables = [Average_Payables]
VAR WorkingCapital = [Working_capital]
VAR RevenuefromOperations = [Revenue from Operations]
RETURN
SWITCH (
TRUE(),
SelectedDisplay = "Current Liabilities", Liabilities,
SelectedDisplay = "Total Equity", TotalEquity,
SelectedDisplay = "Average Shareholders equity [(Opening + Closing)/2]", AverageShareholdersequity,
SelectedDisplay = "Average Inventories [(Opening + Closing)/2]", AverageInventories,
SelectedDisplay = "Average Receivables [(Opening + Closing)/2]", AverageReceivables,
SelectedDisplay = "Average Payables [(Opening + Closing)/2]", AveragePayables,
SelectedDisplay = "Working Capital (Current Assets - Current Liabilities)", WorkingCapital,
SelectedDisplay = "Revenue from Operations", RevenuefromOperations
),
BLANK() // Return blank for "All" time period
