Forum Discussion

ahmchiu's avatar
ahmchiu
Frequent Visitor
2 years ago

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

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    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's avatar
      ahmchiu
      Frequent Visitor
      2 years ago

      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? 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    2 years ago

    Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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