Forum Discussion
Calculate matrix difference with blank data
Hello, please I require your help I need that the data that appear in white appear in 0, and that it generates the difference in the difference column because currently the cases where the cell is empty is not considering it for the difference, I send screenshot of the measurements, if you can help me with the code, Please.
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
4 Replies
Hi,
In my point of view, maybe there is Null value and it is not calculated in your measure, up + 0 after each calculation statement.
If it is not fixed, need to have your PBIX file for investigation
I have not been able to identify the fault, I attach the .pbix file in the following link
https://drive.google.com/file/d/1sq8im63QNXdWnNPKZ5Qm4faUXShGGKud/view?usp=sharing
I need to fill the empty spaces with 0, and that I can make a difference.
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
