Forum Discussion

sagarsahoo_123's avatar
sagarsahoo_123
Helper IV
3 years ago
Solved

Need help to write DAX code for the below Query

Hello Team, As i am new to this DAX code, i need your support to write the code for the below requirement. I have posted the sample table to make it simpler to understand. I have a table having thr...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    Hi sagarsahoo_123 ,

     

    This issue may caused by space value and blank value. Please check your Source data in Power Query. You can use Replace Value in Power Query.

    Here is a simple example:

    As you can see in the images, the two values are different in Text data type.

    You can use Replace Value:

     

    Final output:

    Best Regards,

    Jianbo Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

johnt75's avatar
johnt75
Super User
3 years ago

try

Col A total =
CALCULATE (
    SUM ( 'Table'[Column A] ),
    ISBLANK ( 'Table'[Column B] ),
    NOT ISBLANK ( 'Table'[Column C] )
)