Forum Discussion
DAX Measure Calculation – Returning Empty Values
Hi toum ,
I suggest testing it step by step, variable by variable to show which step actually filters data out.
What is your calculation for minselecteddate and maxselecteddate? Does it return static or dynamic values when you show it in table?
Try testing each of these variables on table with actual data.
Why? Because mostly variable returns correct value when checking using card visual. However, when we put it in table with different dimensions, it actually shows dynamic (different) value per each row, comparing to card visual which shows always static value.
In addition, maybe you should be using ALL statement somewhere. There is possibility that one of parameter conditions is filtering out data.
Cheers,
Nemanja
Thank you for your answer. Yes, I tried to create a new column for each condition to check which rows should be counted. I should see some amounts based on the filters I chose, but I always get an empty value. The MinSelectedDate and MaxSelectedDate are measures that, in my case, represent the minimum/max date selected in the slicer used in the report. the date dimension is not linked to the fact table.