Forum Discussion
Post ProdigyData 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
- Daniel29195
Community Champion
Hello IF
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 .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 👍🫡
IFHi, but it is not working as it is working for 08 & 09.
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
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?
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.
