Forum Discussion
Remove Filters
Hello! I'm making a 100% stacked column chart. which is like this: where the value field is given by the store count and legends are the state of the stores. Example: 81.6% do room cou...
the first column is the store count, the second column is the % of the count (which is precisely what I need the chart not to remove from the filter), and the last column "Value" is the percentage that throws away the measure that I create :
Valor = DIVIDE(COUNTA(Base[Store Name]), CALCULATE(COUNTA(Base[Store Nbr]), ALL(Base)))
column 2 and column 4 should give the same value.
I'll be @amitchandak
Hi CLCastroEn ,
How did you calcute the column2 to count stores? Bascially it should show the same result, please see the picture below and check my sample file.
Seems need more details about this issue for further discussion or you can consider sharing a sample file.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.