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
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

Replace 0 with BLANK().

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