Forum Discussion

Baskar's avatar
Baskar
Resident Rockstar
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
Baskar's avatar
Baskar
Resident Rockstar
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

Baskar,

 

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