Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Don't sum an Inventory value

Hi,   I have a situation with a matrix, where I am comparing plan vs Actual Inventory by month for 4 categaries.   But when I select a whole year, the inventory values of all months get summed up...
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share the download link of your PBI file and show the expected result very clearly.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Ashish_Mathur , 

       

      Thanks for the solution. Just one modification needed.

       

      My 'Plan Inv' shows inventory of December 2022, while my 'Actual Inv' shows inventory of the current month when no date filter is selected.

      Is there a way 'Plan Inv' can show data of the month of 'Actual Inv' when no filter is selected?

       

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        You are welcome.  Why not maintain the discipline of always select a year or year and month?