topic Re: Extra column in my matrix , why ???? in DAX Commands and Tips

Extra column in my matrix , why ????

GouravSingh — Sun, 03 Nov 2024 08:38:15 GMT

When i put a measure, to calculate last 60 days revenue, there is a new column appears in my matrix table

Why this appears there ??

Re: Extra column in my matrix , why ????

xifeng_L — Sun, 03 Nov 2024 09:37:39 GMT

When there are no column fields in a matrix, adding measure to the value fields will add a new column, which is normal. If you are trying to filter the date range of the row, then you can put the measure in the visual object filter pane.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

Re: Extra column in my matrix , why ????

Anonymous — Tue, 05 Nov 2024 06:40:31 GMT

Hi GouravSingh ,

According to your statement, I think your issue is that when you add the measure [60-Days Revenue] into matrix value field, the row field will expand a blank row but shows results in [60-Days Revenue] measure.

As far as I know, this is due to the calculate logic of your measure.

I think you might use function like ALL()/REMOVEFILTERS()/ALLSELETED()/ALLEXCEPTED().
This will remove the filter on date in your calculation and cause that measure return result in the row which should be blank by filter.

Please check whether the result is correct. If it is, you can remove blank in visual level filter by filter the [End of month] column.

Best Regards,
Rico Zhou

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

Re: Extra column in my matrix , why ????

GouravSingh — Tue, 05 Nov 2024 15:54:35 GMT

Hi Anonymous

First of all, thanks to reply on my query.

I didn't used any of the mentioned function,

The original function that have been posted here

60-Day Revenue = CALCULATE( [Total Revenue], DATESINPERIOD('Calendar'[date],MAX('Calendar'[date]),-60,DAY) )

Please let me know, if you required any other details.

Thank you!!

Re: Extra column in my matrix , why ????

GouravSingh — Tue, 05 Nov 2024 16:01:56 GMT

Thanks for your explanation.

Can you please explain again , i didn't understand?? 😥

Re: Extra column in my matrix , why ????

Anonymous — Wed, 06 Nov 2024 08:39:49 GMT

Hi GouravSingh ,

I think your issue is caused by your data model. If the result is correct, I think you can remove the empty row by filter.

If this reply still couldn't solve your issue, you can share a easy sample file with us and show us with result you want. This will make it easier for us to find the solution.

Best Regards,
Rico Zhou

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