Forum Discussion
Helper ICalculate not showing total distinct count
vani wrote:Anonymous I have 6 types of football . Your solution won´t work
It is workable if you arrange your types as 1, 2, 4, 8, 16, 32... but... ya, that's pretty geeky :) Ya... should have seen in your huge FILTER() statement about the 6 types.
Okay, let's talk about why your solution isn't working.
Because you have Clubs on rows, each of those rows is evaluating your expression for just that 1 club. And that is doing what you expect (there is a 2, but no other numbers). [though, it is probably easier to do... a HASONEVALUE('Inscrições'[ID TIPO FUTEBOL]) and VALUES('Inscrições'[ID TIPO FUTEBOL]) = 2) ... maybe filtered for positive types... rather than the big condition you hae now].
Anyway, when you get to the grand total... you are NOT looking at just 1 club, you are looking at all clubs... and if you look at the entire set, it just doesn't match your criteria.
I suspect this is an easy way to resolve your issue for the grand total:
FixedCount := SUMX( VALUES ('Inscrições'[ID CLUB] ); [Disctinct Clubs])
Helper Ivani I replicate your example with other info and this is that i got.
Why don't you try to achieve it first without filters? And also check if category label in format is on.