Hello,
I am still new to power BI and DAX. Currently I am trying to plot line graphs for survey questions that have a line for each response, and these were asked on a monthly basis. I have managed to figure out how to have the lines add up to 100% at each monthly interval using this formula
% A2d Response1 =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[A2D] = "Response1" )
/ CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT('Table','Table'[Month]))
However, I also have lots of slicers on each dashboard page, and when they are replied I still need the percents at each month to add up to 100%. For example, the survey was asked in several countries, and when I select a country using slicer the percents at each month no longer add to 100. I have been trying to include them in the ALLEXCECPT function:
% A2d Response1 =
CALCULATE ( COUNTROWS ( 'Table' ), 'Table'[A2D] = "Response1" )
/ CALCULATE ( COUNTROWS ( 'Table' ), ALLEXCEPT('Table','Table'[Month], 'Table'[Country]))
However, I get an error message saying cant convert value of type text to TRUE/FALSE. Does anyone know a way around this, or a different way of writing my measure to get it to work? Any help greatly appreciated!
Thanks!
