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 bunch of monthly reports example current Employee count or current stock.
when I showed them in a chart at monthly level ( no issue)
at year level (it should show the value for December, PBI "SUM" the values which is wrong,)
I tried
count for December =
CALCULATE(
SUM('data'[count]),
'data'[Date].[Month] IN { "December" },
ALL('data'[Date].[MonthNo])
)
at year level ( worked fine )
at month level (it should show the value for December for all months)
help 😅
@omar8000 , it better to have month column for this
like
count for December =
CALCULATE(
SUM('data'[count]),
'data'[Month] = "December"
)
or
count for December =
CALCULATE(
SUM('data'[count]),
'data'[Date].[Month] = "December" ,
ALL('data'[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 |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |