Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have sucessfully produced a running total from a pivoted table however I now need to stop the measure producing a flat line at once the data doesnt carry on increasing. See graph with annotation.
Table:
Index | Attribute | Date |
46524 | Finish | 17-Feb-17 |
46527 | Finish | 17-Feb-17 |
42683 | Finish | 03-Mar-17 |
42687 | Finish | 03-Mar-17 |
42692 | Finish | 03-Mar-17 |
5234 | Finish | 17-Nov-17 |
5236 | Finish | 17-Nov-17 |
5238 | Finish | 17-Nov-17 |
45005 | ActualFinish | 28-Jul-17 |
45634 | ActualFinish | 28-Jul-17 |
45635 | ActualFinish | 28-Jul-17 |
45636 | ActualFinish | 28-Jul-17 |
45637 | ActualFinish | 28-Jul-17 |
45428 | ActualFinish | 12-Sep-17 |
45429 | ActualFinish | 12-Sep-17 |
Current Graph:
Measure Used:
Cumu Actual Finish = CALCULATE ( COUNTA ( Asta_FullOutput_Pivoted[Index] ), FILTER ( ALL ( Asta_FullOutput_Pivoted ), Asta_FullOutput_Pivoted[Date] <= MAX ( Asta_FullOutput_Pivoted[Date] ) ), FILTER ( ALL ( Asta_FullOutput_Pivoted ), Asta_FullOutput_Pivoted[Attribute]="ActualFinish" ) )
Hi Everyone,
Actually in our organization, operating with multiple projects (Called as Project Codes) under the project Code we are feeding data on amonthly basis with Cost wise, Expense code wise, Funding Codes and Output Codes. Like the below attached screen shot.
My question is, How can I filter data period wise and Project wise cumulative amounts under the each section of budget and actual. Kindly advice me support me?
The Burn rate is not changing and it is like frozen.
Kindly advice and guide me
HI @chris_k
You could try wrapping an IF function around it with a test on Date.
Cumu Actual Finish = VAR myVal = CALCULATE ( COUNTA ( Asta_FullOutput_Pivoted[Index] ), FILTER ( ALL ( Asta_FullOutput_Pivoted ), Asta_FullOutput_Pivoted[Date] <= MAX ( Asta_FullOutput_Pivoted[Date] ) ), FILTER ( ALL ( Asta_FullOutput_Pivoted ), Asta_FullOutput_Pivoted[Attribute]="ActualFinish" ) ) RETURN IF(MAX(Asta_FullOutput_Pivoted[Date]) > MAX('date column from axis'), BLANK() , myVal )
Unfortunately this give the exact same result...
Hi @chris_k
I cannot repro your issue with your shared sample data. Could you please share us your pbix file with One Drive or Dropbox or something else if possible?
Thanks,
Xi Jin.
Did you figure this out? I have exactly the same challenge!
Hi
For the following formula:
User | Count |
---|---|
128 | |
112 | |
100 | |
65 | |
62 |
User | Count |
---|---|
136 | |
116 | |
102 | |
71 | |
57 |