Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Count Rows based on dynamic column value

Hi, I have a stacked bar chart with a line graph on and as a tooltip, I want to show the percentage value of each stack. I've tried various solutions, but to no avail. For example, for 2019, when I h...
ALLEXCEPT
COUNTROWS
distinctcount
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , try a measure like


Percentage = divide(DISTINCTCOUNT('Overview'[First_NID]),CALCULATE(DISTINCTCOUNT(Overview[First_NID]),filter(allselected(Overview),Overview[First_Year]) =max(Overview[First_Year])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks, amitchandak! However, it's still not working. I receive the following error message - A function 'FILTER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.