Hi
i have a table with two columns in a model Table1[Store] and Table1[Sales]
in my report Stores in row and Sum(Table1[Sales]) in values
how can i show the % share
divide([Total Sales],calculate([Total Sales],ALL(Table1[Store]))) this formula is fine when all store is selected, but when few stores are selected from store slicer, % showing wrong. i need % share from selected stores only
i have a table with two columns in a model Table1[Store] and Table1[Sales]
in my report Stores in row and Sum(Table1[Sales]) in values
how can i show the % share
divide([Total Sales],calculate([Total Sales],ALL(Table1[Store]))) this formula is fine when all store is selected, but when few stores are selected from store slicer, % showing wrong. i need % share from selected stores only
