Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a table with a column called FY_Budget(full year budget). It is the amount for YTD for amount in Decmeber e.g 89622100.00
SQL Table (Direct Mode)
I have also created column FY_Budget2 which has inserted the amount across all rows for that account.
The FY_Budget needs to display for every month which is selected.
Attempt 1, a Measure
FY_Budget it is correct for December only & FY_Budget2 in the matrix table it displays for each month but the matrix multiply's it and the displayed amount is inorrect.
I have tried don't summarize and creating a duplicate table without a join to the period table but that didn't work and I am now out of ideas. I thought the matrix would just display the column as is particularly for FY_Budget2 but it's multiplying it, so IDK.
Any help would be appreicated.
Thanks
Solved! Go to Solution.
@Anonymous ,
You can modify the measure as below:
FY Budget =
CALCULATE (
( SUM ( GrpCon_Leaf[Amount] ) ),
FILTER (
GrpCon_Leaf,
GrpCon_Leaf[PCP/ACT/BUD/RFC] = "Budget"
&& GrpCon_Leaf[Period] = SELECTEDVALUE ( GrpCon_Leaf[Period] )
)
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous ,
You can modify the measure as below:
FY Budget =
CALCULATE (
( SUM ( GrpCon_Leaf[Amount] ) ),
FILTER (
GrpCon_Leaf,
GrpCon_Leaf[PCP/ACT/BUD/RFC] = "Budget"
&& GrpCon_Leaf[Period] = SELECTEDVALUE ( GrpCon_Leaf[Period] )
)
)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |