I need the matrix to display the values ​​of the days equal to or less than the filtered day

[natico]

I need to make a matrix in power bi similar to this table. If, for example, I filter the day Wednesday, the matrix should only display data for Monday, Tuesday and Wednesday.

It should look something like this:

I was thinking of making a measure that would see the name of the day selected in the filter and assign the number that corresponds to that day of the week. And then compare that number with the number that would correspond to the day of the line. If it is less than or equal, it would bring in sales. If it is not, it must come blank.

Sales Pairs TY Report =
VAR NumDiaSeleccionado = MAX(D_DATES[day_week_number])
VAR SemanaSeleccionada = SELECTEDVALUE('D_DATES'[weekBATA])
VAR AnioSeleccionado = SELECTEDVALUE('D_DATES'[year])
RETURN
IF (
MAX(D_DATES[day_week_number]) <= NumDiaSeleccionado &&
MAX(D_DATES[weekBATA]) = SemanaSeleccionada &&
MAX(D_DATES[year]) = AnioSeleccionado,
[Sales Pairs TY],
BLANK()
)

But as you can see, the measure of the filtered day number does not work and takes the number of each row so it always meets the condition of being equal and brings data.

[v-zhangti · Accepted solution]

Hi, @natico 

You can try the following methods.

Sample data:

Create a new slicer table:

Slicer = SUMMARIZE(D_DATES,D_DATES[Name],D_DATES[Weekday])

Measure = IF(SELECTEDVALUE(D_DATES[Weekday])>SELECTEDVALUE(Slicer[Weekday]),BLANK(),SUM(D_DATES[Sales]))

Is this the result you expected? Please refer to the attachment.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[BeaBF]

@natico Hi! Try with this adjusted measures:

FIRST:

SelectedDayNumber = SELECTEDVALUE('D_DATES'[day_week_number])
SECOND:

Sales Pairs TY Report =
VAR SelectedDayNumber = [SelectedDayNumber]
VAR DayOfWeekNumber = SELECTEDVALUE('D_DATES'[day_week_number])
VAR SemanaSeleccionada = SELECTEDVALUE('D_DATES'[weekBATA])
VAR AnioSeleccionado = SELECTEDVALUE('D_DATES'[year])

RETURN
IF (
DayOfWeekNumber <= SelectedDayNumber &&
MAX(D_DATES[weekBATA]) = SemanaSeleccionada &&
MAX(D_DATES[year]) = AnioSeleccionado,
[Sales Pairs TY],
BLANK()
)

BBF

[Greg_Deckler]

@natico See if this helps: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M5...