Forum Discussion

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident 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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Baskar,

 

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

 

Thank you,

Niket Talati

  • Baskar's avatar
    Baskar
    Icon for Resident Rockstar rankResident Rockstar
    9 years ago

    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's avatar
      Anonymous
      Not applicable
      9 years ago

      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's avatar
        Baskar
        Icon for Resident Rockstar rankResident 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)