Forum Discussion
Group aggregated data using date slicer
Hi, I tried to get a solution here: https://community.powerbi.com/t5/Desktop/Remove-0-from-balance-list/m-p/1150852 But I try to reframe: Is it possible to create something like a group b...
Anonymous add another measure that will filter out the zeros
No Zero Measure = SUMX ( VALUES ( Table[Account] ), IF ( [Sum Amount Measure] > 0, [Sum Amount Measure] ) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous add another measure that will filter out the zeros
No Zero Measure =
SUMX ( VALUES ( Table[Account] ), IF ( [Sum Amount Measure] > 0, [Sum Amount Measure] ) )
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡