Forum Discussion
Solved
Reference current row value in Filter expression
Hi , I seem to be struggling with a problem in PowerBI. I will try to explain the issue with the Product and Sales table example . In my report , I have a drop down filter for Product and I ha...
=VAR _prdcat=VALUES(Product[ProductCategory]) RETURN CALCULATE(SUM(Sales[Sales]),FILTER(ALL(Product,Product[ProductCategory] IN _prdcat))
=VAR _prdcat=VALUES(Product[ProductCategory]) RETURN CALCULATE(SUM(Sales[Sales]),FILTER(ALL(Product,Product[ProductCategory] IN _prdcat))
Thank you so very much !!!! That worked .
Very grateful for your help .
