Forum Discussion
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...
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:
Hope this helps.
Best Regards,
Giotto Zhi
v-gizhi-msft
Community Support
Community SupportHi,
Please try these two measures:
PO Total = SUM('Table'[Approved PO Amount])PO Lines = COUNTROWS('Table')
The result shows:
Hope this helps.
Best Regards,
Giotto Zhi
edit / nvm - figured it out. I can use the measure and apply a filter to it....