Forum Discussion
Calculate matrix difference with blank data
Ready friend, I already solved it, the error came from the measures where I calculate the differences, I need to add the ALSELLECTED function within the MAXX and MINX function at the time of declaring the variables. And in the measure of difference add the +0 for when there is no data.
https://drive.google.com/file/d/1KP4kGJo6qQNyhgNhVlrzv3ZdJtnx0Okc/view?usp=sharing
Hi,
In your measure, I just add the '+ 0' to the script and now there isn't any null value, but the issue is not because of the null value.
As I marked below pic, you compare the dates together in separate tables, and according to the Filter Dax code, there is just one record in each table to calc (one for 202206) and others is for 202205 and never comes in your dax.
I think you need to change your Dax codes and compare other column(s) or do in another ways
Ready friend, I already solved it, the error came from the measures where I calculate the differences, I need to add the ALSELLECTED function within the MAXX and MINX function at the time of declaring the variables. And in the measure of difference add the +0 for when there is no data.
https://drive.google.com/file/d/1KP4kGJo6qQNyhgNhVlrzv3ZdJtnx0Okc/view?usp=sharing