Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Problem in Dax and Relationship

Hi All,   Thanks Advanced !!!   Problem : I was getting value like cross join when connecting three tables. This prob is occurs when i was replace Isblank  with 0 in DAX Measure.    Importance ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

Thanks for the quick response! Appreciate it.

 

Yes, I have used isblank DAX and replacing it with 0. Here is my measure: 

 

Relevant Opportunities Closed = IF(ISBLANK(CALCULATE([Total Opportunities],FILTER(d_Opportunity,d_Opportunity[Opportunity Status]="CLOSED"))),0,CALCULATE([Total Opportunities],FILTER(d_Opportunity,d_Opportunity[Opportunity Status]="CLOSED")))

 

Could you please help me to resolve this issue?

 

Thanks,

Niket Talati

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Try this one Dude,

 

 

Relevant Opportunities Closed =

 

var X=CALCULATE([Total Opportunities],FILTER(d_Opportunity,d_Opportunity[Opportunity Status]="CLOSED"))

 

return if (isblank(X),blank(),X)

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Anonymous,

     

    Thanks for the response and new DAX. Unfortunetly it doesn't work with my scenario since I need to display 0 in place of blank. So when I replace blank with 0 through your DAX, the orignial issue is reproducing again.

     

    Any other tips on this?

     

    Regards,

    Niket Talati