Forum Discussion

EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
3 years ago

Incorrect Column Total: Row/Grand Totals are good

Hi All, I have found my most bizzare case in Power BI yet and would love some help. My measure is returning correctly for each row, but fails when calculating the column totals. For sake of debugg...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share the download link of the PBI file.

EnrichedUser's avatar
EnrichedUser
Icon for Helper III rankHelper III
3 years ago

I am unfortunally not able to at this time. But the model is extremely simple. 
There is only two tables and both are included below.

Receipts:

Eff DateQuantitySite_Item_Key
3/13/2023100SFA250
3/31/2023100SFA250
6/26/2023100SFA250
1/12/20236SFA479
4/3/202310SFA479
5/11/202310SFA479
6/22/2023305SFA479

 

Date:

 

Date = 
ADDCOLUMNS (
   CALENDAR ( DATE(2023,1,1), DATE(2023,12,31) ),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "MMM" ),
    "Month No", MONTH ( [Date] ),
    "Quarter", "Q" & CEILING ( MONTH ( [Date] ) / 3, 1 ),
    "Week No", WEEKNUM ( [Date] ),
    "Weekday", FORMAT ( [Date], "dddd" ),
    "Weekday No", WEEKDAY ( [Date], 2 ) + 1,
    "Year Month", FORMAT ( [Date], "MMM yyyy" ),
    "Month Year No", YEAR ( [Date] ) * 100 + MONTH ( [Date] ),
    "Week Year", YEAR ( [Date] ) * 100 + WEEKNUM ( [Date] ),
    "Month Sort", YEAR ( [Date] ) * 10000 + MONTH ( [Date] ),
    "Week Sort", YEAR ( [Date] ) * 10000 + WEEKNUM ( [Date] )
)