Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi, I would like to display the values as SUM of TOTAL PER YEAR as listed on the EXPECTED column below..
How do I do this correctly because on my graph that I have been developing it is displaying as the Total Allotted instead of the EXPECTED..
I have been experimenting with formulas but no luck 😞
Solved! Go to Solution.
@GA1993 try this
Measure:= calculate(sum(tbl[TotalAllotted]),allexcept(tbl,tbl[year]))
@GA1993 try this
Measure:= calculate(sum(tbl[TotalAllotted]),allexcept(tbl,tbl[year]))
Hi,
It doesnt seem to accept the suggested solution. I think the FACT DAX doesnt work 😞
@GA1993 Fact is the name of the table. Edited, try again.
Is there a reason why the Year is not acccepted? I have made the relationship between the MP Engine and Date so Im not sure where the issue is 😕
@GA1993 what does the error say?
It says it cannot find the name Year
But this is my Date table
try:
'Date'[Date].[Year]
@GA1993 use a Date table, and not date hierarchy. You can find plenty of examples in this forum & / web about DAX Date table.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
11 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |