Forum Discussion

DataFunness's avatar
DataFunness
Helper I
1 year ago

Filter Matrix on Percent Change

Hello, I am trying to take only records that have a percent change where the percent change is above 50% or below -50%. It isn’t comparing year to date sales to sales year to date last year. The ask...
Need Help
parry2k's avatar
parry2k
Super User
1 year ago

DataFunness It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

  • DataFunness's avatar
    DataFunness
    Helper I
    1 year ago

    Hi parry2k and Anonymous ,

     

    The overall report has many pages.  The Summary Page will display 1 measure from each page.  In this pbix example, I need the “Growth Increase or Decrease” total at the bottom of the Existing Customers page to go to the Summary page.  This is the one I’m having a problem with. 

     

    The New Customer page is an example of how the total for New Customers is displayed on the Summary Page as expected.  


    I created dummy data to match our data and part of our hierarchy. I may have switched between using  the names customer and dealer, but they are one in the same.  I added comments in the pages in the report.  I attached a CSV of the export of the Existing Customers page that shows how I the expected rows to be included for Existing Customers.  Please let me know what questions you have and thank you very much. 


    Thank you so much

     

    Link to files:  https://drive.google.com/drive/folders/13WGEsrVPOh9VqvIHZ-_Pwzlh3mu-M_5m?dmr=1&ec=wgc-drive-globalnav-goto