Forum Discussion
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 : 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.
Anonymous
9 Replies
Replace 0 with BLANK().
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.
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
