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

     

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.

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks so much.

     

    I would not have thought about doing it this way.