Issue with matrix in Power BI Desktop

[jisaenz]

Using Power BI Desktop April 2024 I have an issue when I use a measure as a value in matrix that contain additional values the matrix displys the values for the measure but is showing blanks for the other values. The measure that I am using is PO Next Weeks = VAR SelectedWeeks = SELECTEDVALUE('Weeks to include'[Weeks To Include]) VAR CurrentPeriodID = SELECTEDVALUE(Week_Site_Part_Periods[Period_ID]) VAR Result = CALCULATE( SUM('Purchase Orders'[PO]), ALL(Week_Site_Part_Periods[Period_ID]), Week_Site_Part_Periods[Period_ID] + 1 > CurrentPeriodID && Week_Site_Part_Periods[Period_ID] + 1 <= CurrentPeriodID + SelectedWeeks ) RETURN(IF(ISBLANK(Result), 0, Result))

[Anonymous]

@jisaenz  I have a few questions: I assume the 'Purchase Orders'[PO] field contains a dollar amount? Why are you using the ALL function in the Result variable?

[jisaenz]

Those are the results in the matrix withouth the PO Next Weeks

[jisaenz]

this is the result whn I include the measure in the matrix

[jisaenz]

PO is qunatity with 0 decimals I am using all in the Result to allow me to use all Period_ID diffrent tahn the actual selected Period_ID

[jisaenz]

Still showing other coulmns in balnk and display the same values for PO Next Weeks 664227 with all shows the currect numbers

[Sahir_Maharaj]

Hello @jisaenz,

Can you please try the following:

PO Next Weeks = 
VAR SelectedWeeks = SELECTEDVALUE('Weeks to include'[Weeks To Include])
VAR CurrentPeriodID = SELECTEDVALUE(Week_Site_Part_Periods[Period_ID])
VAR Result = CALCULATE(
    SUM('Purchase Orders'[PO]),
    ALLEXCEPT(Week_Site_Part_Periods, Week_Site_Part_Periods[SomeOtherColumn]),
    Week_Site_Part_Periods[Period_ID] + 1 > CurrentPeriodID && 
    Week_Site_Part_Periods[Period_ID] + 1 <= CurrentPeriodID + SelectedWeeks
)
RETURN IF(ISBLANK(Result), 0, Result)