Forum Discussion
Distinct Count dependent on slicer
FYI, got it to work by creating a summarized table by the projects. I then adjusted my meet goal formula with :
if ( hasonevalue(table[lab], calculate( distinctcount(table[project]), filter(table, table[Expensed %] >= to ExpensedGoal))), calculate( distinctcount(table[project]), filter(calculatedtable, calculatedtable[Expensed %] >= to ExpensedGoal)))
definately not the best way to go about it, but is my work around until I get something else working.
It still seems to be counting the same. I created the collumn and then changed the formula to:
Meet Goal = calculate( distinctcount(table[project]), filter(table, table[Expensed %] >= to ExpensedGoal)))
When I click the slicer for an individual lab it counts correctly, it is only when all are selected that it seems to count a project as long as the goal is met in at least one of the associated labs
FYI, got it to work by creating a summarized table by the projects. I then adjusted my meet goal formula with :
if ( hasonevalue(table[lab], calculate( distinctcount(table[project]), filter(table, table[Expensed %] >= to ExpensedGoal))), calculate( distinctcount(table[project]), filter(calculatedtable, calculatedtable[Expensed %] >= to ExpensedGoal)))
definately not the best way to go about it, but is my work around until I get something else working.