Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Guys.
Feels like mental block, but I can't seem to work out a simple sum.
So here's what I am after:
A formula that should give me a sum of the budget based on dates, work oders.
In the example below, for the same site, I would like 07/2022 sum to be 2850+200 = 3050 and 08_2022 sum to be 6050.
When I try changing the column value to SUM, it gives a weird summation:
Any help would be appreciated. Thank you
Solved! Go to Solution.
Hi,
You may download my PBI file from here.
Hope this helps.
You are welcome. Attached.
Hi @azakir
try
CALCULATE(
SUM(Table1[Model WO Budget]),
FILTER(
ALLSELECTED(Table1[WO_Status_Change_MK_Date])
)
)
BR
Thank @Anonymous
But I am getting the following error:
Hi @azakir ,
Please try this instead
CALCULATE(
SUM(Table1[Model WO Budget]),
ALLSELECTED(Table1[WO_Status_Change_MK_Date])
)
Thanks @Anonymous
The formula worked, and it's giving me a SUM.
What I am really after is SUM of "Don't Summarize" Model WO Budget.
So for July, it should be 2850+200 = 3050
Hi,
Share the download link of your PBI file.
Hi,
You may download my PBI file from here.
Hope this helps.
Thank you for that. The result looks exactly what I was after. But I can't seem to download the file. Can you please share through another link.
You are welcome.
Hi
Step 1: Create a calculated tableTable = SUMMARIZE(Sheet1,Sheet1[Model WO Budget],'Calendar'[Period],Sheet1[Work_Order])
Step 2: Create a MeasureMeasure = CALCULATE( SUM('Table'[Model WO Budget]), ALLSELECTED('Table'[Work_Order],'Table'[Model WO Budget]) )
Step 3: Visualize on Matrix
BR If that helps please mark this as a solution
Cheers @Anonymous
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |