Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sum by Group - output question

Hi 🙂   I have a fairly simple question - tried searching but my answer may be lost in the countless posts on this.   I have a table that contains purchase orders, and each row is one line of eac...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create a What If parameter such as below:

    It will automatically create a slicer.

    Then create a check measure:

    Check = IF([PO Total]<SELECTEDVALUE(Parameter[Parameter]),1,0)

    Apply this measure to the original table visual.

    For example, i define a policy that the result only shows the rows which [PO Total] is less than the specified value from slicer.

    The result shows:

    Here is my test pbix file:

    pbix 

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Create measures

PO Lines = count(table[PO Line Number])
PO Total = sum(table[Approved PO Amount])

 

Rest should automatically group in Table and matrix

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Guys,

     

    Thanks so much for the help, it works great.

     

    Before I mark this as solved, I have another question.

     

    What would be the best way to add a filter to the report so the end user can view only the POs up to or under a certain value?

     

    For example, they want to only see POs up to $5000?

     

    Thanks

    • v-gizhi-msft's avatar
      v-gizhi-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi,

       

      In your original sample table i can not see any data up to $5000.

      But if you want to apply filter to this visual, you can choose the specified field as a slicer, or directly add a filter to Filter Pane.

       

      Best Regards,

      Giotto Zhi

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        The table was an example only as the real dataset is huge and contains sensitive information.

         

        The field I want to filter by is the PO Total measure, but it wont allow me to use it on a slicer...?

         

        I cant use the filter pane, I would rather have the user interact with the dashboard directly.

         

        Thanks.