Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Formula not display correct result

Hi, Please see below formula,It gives me the correct result but result display is not correct. When below forumla condition does not meet it should display 0 in a current d rows but it is showing t...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,
    I'm not sure, what kind of error you try to catch, AVERAGE(..., ...) returns BLANK() if the application of the filter from the CALCULATE filter out all rows in the current FILTER context.

     

    Maybe you should give ISBLANK() a try like so:

    var thevalue = CALCULATE(<your CALCULATE(...)>)
return
IF(ISBLANK(thevalue), 0, thevalue)

    If this does not help, maybe you can provide a pbix file with some sample data, upload the pbix to onedrive or dropbox and share the link.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
7 years ago

Hey,
I'm not sure, what kind of error you try to catch, AVERAGE(..., ...) returns BLANK() if the application of the filter from the CALCULATE filter out all rows in the current FILTER context.

 

Maybe you should give ISBLANK() a try like so:

var thevalue = CALCULATE(<your CALCULATE(...)>)
return
IF(ISBLANK(thevalue), 0, thevalue)

If this does not help, maybe you can provide a pbix file with some sample data, upload the pbix to onedrive or dropbox and share the link.

 

Regards,

Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Tom,

    Thank you so much it is working pefectly fine .

    You can see the result below.

    • TomMartens's avatar
      TomMartens
      Super User
      7 years ago
      Perfect!