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

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.

  • 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