Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
IF
Post Prodigy
Post Prodigy

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 right result for other two months. can you help me on this? I loaded the file to: https://we.tl/t-0RAbKj0jlU

thank you

11 REPLIES 11
v-xiandat-msft
Community Support
Community Support

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

vxiandatmsft_0-1706250153872.png

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.

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 

Hi @IF ,

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

vxiandatmsft_1-1706258028206.png

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.

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

Hi @IF ,

Okay,my pleasure

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.

result.JPG

 

Hi, exactly, it should be empty. 

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:

vxiandatmsft_0-1706506482246.png

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

vxiandatmsft_5-1706507034954.png

The result shows exactly this value:

vxiandatmsft_4-1706507017765.png

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:

vxiandatmsft_3-1706506886949.png

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.

 

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

Hi, but it is not working as it is working for 08 & 09.

2.JPG

Daniel29195
Super User
Super User

Hello @IF 

Daniel29195_0-1706173110314.png

if this is what you meant, 

simply create a measure : 

Measure = CALCULATE(SUM(Main[Value1]))
 
and add that measure in the filter pane for each slicer you want to be affected by the filter of the other slicers . 
 
Daniel29195_2-1706173177652.png

 


 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos 👍🫡

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.