Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi.
I have the following matrix with the measures Sales and Goal by month; I have a third measure called Sales*, this shows the value of Sales if the month is not closed yet or shows the value of Goal otherwise; the dax expression for this measure is shown in the second image. The problem is that the Total show in the matrix is not correct given the values in every column.
Thank you in advance for your help.
Solved! Go to Solution.
please try
Sales* =
SUMX (
VALUES ( 'Calendario Venta'[Month Name] ),
CALCULATE (
VAR reportingDate =
MAX ( 'BC Ventas'[Fecha Exp] )
VAR endMonth =
EOMONTH ( reportingDate, 0 )
RETURN
IF (
OR ( reportingDate < endMonth, ISBLANK ( reportingDate ) ),
SUMX ( VALUES ( 'Calendario Venta'[Date (bins)] ), Medidas[Goal] ),
SUMX ( VALUES ( 'Calendario Venta'[Date (bins)] ), [Sales] )
)
)
)
please try
Sales* =
SUMX (
VALUES ( 'Calendario Venta'[Month Name] ),
CALCULATE (
VAR reportingDate =
MAX ( 'BC Ventas'[Fecha Exp] )
VAR endMonth =
EOMONTH ( reportingDate, 0 )
RETURN
IF (
OR ( reportingDate < endMonth, ISBLANK ( reportingDate ) ),
SUMX ( VALUES ( 'Calendario Venta'[Date (bins)] ), Medidas[Goal] ),
SUMX ( VALUES ( 'Calendario Venta'[Date (bins)] ), [Sales] )
)
)
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |