Forum Discussion
Visual not filtering correctly
Hi Anonymous ,
Thanks for the suggestion. The problem is that I have other visualizations that use the relationship between the Currency table and Dates table (based on Date field). If I remove this relationship then it throws off the other visualizations which run off a Year/Month Slicer.
Is there a way to run both of these relationships at the same time (Dates/Currency and Bulking/Currency)?
Thanks for your help on this.
Hi artblakey ,
Could you please share your sample pbix file with me if it is convenient? Later I will check if there is any other method/workaround to achieve it base on your report file. You can upload it to OneDrive for Business and share the link with me. Thank you.
Best Regards
Rena
Hi Anonymous
Here is the link for the pbix file from OneDrive. Please let me know if you have any questions.
Thanks.
Hi artblakey ,
Sorry for late response. I made some changes on your provided report file to update the formula of measure Gross and Net as below:
Gross = CALCULATE(SUM(Bulking[Gross Vol]),FILTER('Bulking',Bulking[Count] = 1&&'Bulking'[Currency]=SELECTEDVALUE('Currency'[Currency],"AUDEUR")))+0Net = CALCULATE(SUM(Bulking[Net Vol]),FILTER('Bulking',Bulking[Count] = 1&&'Bulking'[Currency]=SELECTEDVALUE('Currency'[Currency],"AUDEUR")))+0You can get the updated report file from this link.
Best Regards
Rena
Hi Anonymous
Thanks for your reply and for taking the time to help me out.
I looked at the changes but it's not quite giving me the desired results. Apologies as I probably wasn't clear on what I was expecting as the end result. Here is a summary of what I am expecting to see from this report:
April:
APRIL Total Volume
(from Currency table)Gross
(from Bulking table)Net
(from Bulking table)% Difference ALL SELECTED 539,340.57 455,986.82 349,762.26 23.3% AUDUSD 344,280.96 344,635.71 238,460.97 30.8% AUDEUR 195,059.61 111,351.11 111,301.29 0.0% May:
MAY Total Volume
(from Currency table)Gross
(from Bulking table)Net
(from Bulking table)% Difference ALL SELECTED 1,078,681.14 911,973.64 349,762.26 61.6% AUDUSD 688,561.92 689,271.42 238,460.97 65.4% AUDEUR 390,119.22 222,702.22 111,301.29 50.0% It appears with the changes you made, it does work properly when you select and click on either currency, but it is not working correctly when all currencies are selected. For example, for April, when all currencies are selected (no currency filter), I'm expecting a Gross volume of $455,986.82 and Net volume of $349,762.26, with a Percentage Difference of 23.3%. The screenshot below is showing the current results which are incorrect.
I also wanted to mention that this report will be generated on a regular basis, and it will have multiple currencies in future, not just the two shown on this file, but the calculations will always be the same.
Please let me know if I can provide any other information.
Thanks.
Hi,
Is anyone able to help me with this please?
I appreciate all the help from everone so far and it seems like It's getting close, but just need a little more help to get over the line.
Thank you.