Visual filter vs DAX Measure

[ahmchiu]

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 in the measure, I tried to remove that from the measure but included it as a filter on visual (as shown in the amended method below) so that the measure can be used in other calculation too. While the denominator can be correctly filtered under the amended method, the non-blank values are not filtered out in the numerator. Any hints on why would that happened? 

Thank you so much in advance!

Original method

_% of id with positive score =

var _positivescore = CALCULATE(COUNT(contacts[id]),measurement[score] >= 0 && not(isblank(measurement[score])))

var _total = CALCULATE(COUNT(contacts[id]),not(isblank(measurement[score])))

return

DIVIDE(_positivescore,_total)

Amended method

_% of id with positive score =

var _positivescore = CALCULATE(COUNT(contacts[id]),measurement[score] >= 0)

var _total = COUNT(contacts[id])

return

DIVIDE(_positivescore,_total)

[Anonymous]

@amitchandak  @Ashish_Mathur  Thanks for your contribution.

Hi @ahmchiu ,

@amitchandak provided some suggesiton on your problem. Have you gotten the soution? If yes, could you please mark your post as Answered? Otherwise, please provide some fake data to explain the requirement and your expected result just as @Ashish_Mathur suggested. Thank you.

Best Regards

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Also, show the incorrect answer and the expected result.

[ahmchiu]

@Ashish_Mathur sorry, cannot upload th PBI file.. it is connected to my database....

[amitchandak]

@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()) )

[ahmchiu]

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?