Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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]))
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
@GA1993 try this
Measure:= calculate(sum(tbl[TotalAllotted]),allexcept(tbl,tbl[year]))
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
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.
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
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?
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
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.
Proud to be a Super User!
New Animated Dashboard: Sales Calendar
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.