Data display based on the row and selections

Hi IF ,

I just scrutinized your measure and you have all the REGIONS,CITIES,TOWNS in June and July, so your flag_2 must be 4! like this:

When I turned to August and September, I realized that they had one statistic that was completely missing REGIONS,CITIES,TOWNS

The result shows exactly this value:

But your DAX will query the smallest flag_2 every time, since there is only flag_2 = 4 in June and July, he will only calculate and display the value of flag_2 = 4, so he won't be empty, I wrote on top of the other two cards to specifically calculate the case where REGIONS, CITIES, TOWNS are all empty!

Measure = 
   CALCULATE(
     SUM(Main[Value1]),
     FILTER(Main,Main[_Flag_2] = 1)
   )

The final output is shown in the following figure:

Best Regards,

Xianda Tang

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