Problem in Dax and Relationship

[Baskar]

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 : Please help me . Its crash my all previous projects also. Really am in big trouble. What is the solution for this ?

1. RelationshipSalary from Employee Table - Direct columnSalary from DAX Calculation

If i remove the Isblank condition its working fine for me.

@ankitpatira

@Greg_Deckler

@Seth_C_Bauer

@kcantor

@MiguelMartinez

@MattAllington

[v-yulgu-msft]

Hi @Baskar,

The blank value is different from 0 value. When you aggregate values in a visual, the result 0 will be regarded as a numerical value and displayed while the blank will be ignored.

Thanks,
Yuliana Gu

[BhaveshPatel]

Replace 0 with BLANK().

[Baskar]

Hi @BhaveshPatel thanks for your reply.

when i remove 0 am getting the result that i know. But i want to know what is logic runs behind the DAX.

[Baskar]

+ @v-haibl-msft

[Anonymous]

@Baskar,

Did you get the solution? I am also facing this issue. 

Thank you,

Niket Talati

[Baskar]

Yes , I willl help you on this case.

Let me know if u used any measures ? 

If yes the prob is on the measure caluculation.

Eg. In that measure are u used anywhere replace blank with some other value ? 

If yes , that is the prob .

or else pls share your scenario 

[Anonymous]

Hi @Baskar,

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

[Baskar]

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]

@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