topic How to hide or remove first value in YOY% change matrix in DAX Commands and Tips

How to hide or remove first value in YOY% change matrix

FOXYBARK — Wed, 14 May 2025 18:56:31 GMT

HI.

I have the following calculation -

% Change YOY = CALCULATE(DIVIDE(SUM(Dodeca_Financials[YTD]), [LY]) -1)

which works accurately. I also have a simple viz to display my results.

I'm looking for a way to hide the first change and have it be dynamic based on my property filter selection. Filter is not shown for security. I'm okay if it says "N/A" or something like that also.

Thanks

Re: How to hide or remove first value in YOY% change matrix

gmsamborn — Thu, 15 May 2025 00:01:48 GMT

Hi FOXYBARK

would a measure like this help?

% Change YOY = IF( [LY], DIVIDE( SUM( Dodeca_Financials[YTD] ), [LY] ) - 1 )

Let me know if you have any questions.

Re: How to hide or remove first value in YOY% change matrix

maruthisp — Thu, 15 May 2025 01:39:08 GMT

Hi FOXYBARK ,

As per my understanding, You can solve this with a small tweak to your YoY% measure so that it only shows a value when there is a last year to compare and otherwise returns blank or N/A.

I tried to put your solution in the attached pbix file, please check and let me know if you have questions further.
How to hide or remove first value in YOY% change matrix.pbix

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated — thanks!

Best Regards,

Maruthi

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/

X - Maruthi Siva Prasad - (@MaruthiSP) / X