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
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

        Hi, 
        For example, when I select 09.2023 and select City F, it shows blank, however it should be 76.

        Similarly, when I select 07.2023 and select RegionB, it shows blank, however it should be 60.570

        thanks again.

         

  • 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

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

        Thank you very much. I tested it, but it is not providing the right result as I shown below. I will change the structure of the table to make it useable. There is no need to spend time on it. I think it is going to be quite difficult. Again thank you. Have a nice day.