Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hola a todos, tengo estas medidas dax que funcionan bien. Sin embargo, cuando coloco una categoría en la columna, me da una cantidad de repetición extraña. ¿Cómo no mostrar la cantidad repetida? Gracias de antemano.
P&L =
CALCULATE (
SUM ( 'Invoices'[Line Amount Calculation] ),
FILTER (
'Accounts',
Accounts[Class] = "Revenue"
|| Accounts[Class] = "Expense"
)
) - [P&L - Credit Notes] + [P&L (Journals)]
P&L - Credit Notes =
CALCULATE (
SUM ( 'Credit Notes'[Line Amount Credit Note Calculation] ),
FILTER (
'Accounts',
Accounts[Class] = "Revenue"
|| Accounts[Class] = "Expense"
)
)
P&L (Journals) =
CALCULATE (
0 - ( SUM ( 'Journals'[Net Amount] ) ),
FILTER ( 'Journals', 'Journals'[Split] = "JOURNALS" ),
FILTER (
'Accounts',
Accounts[Class] = "Revenue"
|| Accounts[Class] = "Expense"
)
)
Solved! Go to Solution.
@ronaldbalza2023 , la tabla de facturas no se une con la tabla utilizada en fila o columna. Comprobar la unión
@ronaldbalza2023 , la tabla de facturas no se une con la tabla utilizada en fila o columna. Comprobar la unión