Forum Discussion

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
2 years ago

Data display based on the row and selections

Hi, I want to show the data  that is shown in the main table. The slicers should show excatly what the row shows. it is working well for the month 08.2023 and 09.2023. However, it is not showing the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi IF ,

Excuse me, can you tell me exactly what your error is, and what the correct value should be, thank you very much!

I checked the June and July results in your pbix file and they seem to appear to be correct

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.

IF's avatar
IF
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi,

If i select only month, it should be blank for 06and 07.2023, but it is not. There is no value for region, town and citiy. It is working for other months. I have too many types. therefore i will not able to manually add.

Thank you 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi IF ,

    When you pick the months of June and July , these two should be empty, right? 

    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.

    • IF's avatar
      IF
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      Hi, exactly, it should be empty. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        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.

         

    • IF's avatar
      IF
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

      Hello, thanks. The card should be useable for the months june, july, aug, and september. i can not use it for each case. can you share the file? regards