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.
I have a table (shown below) and I want to create a matrix visual that shows the subtotal forecast by month for the Owning Org. I am new to DAX and was wondering how to do this. Currently, the matrix shows a sum total of the entire column (second image)
Solved! Go to Solution.
now you can try
ForecastMeasure =
SUMX (
VALUES ( 'Date'[Month] ),
CALCULATE (
SUM ( 'FY22 Lending Budget'[Forecast] ),
FILTER (
'FY22 Lending Budget',
MONTH ( 'FY22 Lending Budget'[Month/YR] )
= MONTH ( MAX ( 'Date'[Calendar Date] ) )
)
)
)
i did have it on month/yr but changed it to owning org and that made a difference.
now you can try
ForecastMeasure =
SUMX (
VALUES ( 'Date'[Month] ),
CALCULATE (
SUM ( 'FY22 Lending Budget'[Forecast] ),
FILTER (
'FY22 Lending Budget',
MONTH ( 'FY22 Lending Budget'[Month/YR] )
= MONTH ( MAX ( 'Date'[Calendar Date] ) )
)
)
)
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 |
---|---|
54 | |
24 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
60 | |
46 | |
17 | |
12 |