Forum Discussion
Visual filter vs DAX Measure
Hi all, I have set up the following measures to calculate the number of positive score as a % of total. Instead of including the filter (bold in the original method) to filter out the blank score...
ahmchiu , Try one of the two
divide(
countx(values(contacts[id]), if(measurement[score] >= 0 && not(isblank(measurement[score])), [id], blank())),
countx(values(contacts[id]), if( not(isblank(measurement[score])), [id], blank())) )
or
divide(
countx(values(contacts[id]), if(measurement[score] >= 0 && not(isblank(measurement[score])), [id], blank())),
calculate(countx(values(contacts[id]), if( not(isblank(measurement[score])), [id], blank())), allselected()) )
Instead of putting "&& not(isblank(measurement[score]))" within the DX formula, I am trying to remove it from the formula and replace it using a visual filter. Is it possible?