topic Re: I need the matrix to display the values of the days equal to or less than the filtered day in DAX Commands and Tips

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

natico — Fri, 06 Oct 2023 13:38:23 GMT

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.

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

Greg_Deckler — Fri, 06 Oct 2023 13:38:44 GMT

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

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

BeaBF — Fri, 06 Oct 2023 17:41:53 GMT

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

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

v-zhangti — Tue, 10 Oct 2023 02:58:17 GMT

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.

topic Re: I need the matrix to display the values ​​of the days equal to or less than the filtered day in DAX Commands and Tips

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

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

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

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

topic Re: I need the matrix to display the values of the days equal to or less than the filtered day in DAX Commands and Tips

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

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

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

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