Forum Discussion

artblakey's avatar
artblakey
Helper I
6 years ago

Visual not filtering correctly

Hi friends,   Hope someone can assist me please.   I'm currently using three visuals in PowerBI: 1. A bar chart for different currencies and corresponding volume (eg. AUD, EUR. GBP etc.) 2. A c...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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")))+0
Net = CALCULATE(SUM(Bulking[Net Vol]),FILTER('Bulking',Bulking[Count] = 1&&'Bulking'[Currency]=SELECTEDVALUE('Currency'[Currency],"AUDEUR")))+0

You can get the updated report file from this link.

Best Regards

Rena

  • artblakey's avatar
    artblakey
    Helper I
    6 years ago

    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.2623.3%
    AUDUSD                            344,280.96                      344,635.71                    238,460.9730.8%
    AUDEUR                            195,059.61                      111,351.11                    111,301.290.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.2661.6%
    AUDUSD                            688,561.92                      689,271.42                    238,460.9765.4%
    AUDEUR                            390,119.22                      222,702.22                    111,301.2950.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.

  • artblakey's avatar
    artblakey
    Helper I
    6 years ago

    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.