Forum Discussion

collinq's avatar
collinq
Super User
5 years ago

HI mdaamirkhan ,

 

My guess is that you have some non-conforming data in those columns when you do not slice the data down.  In other words, you have some "blanks" or some non-numeric data or an error data of some sort in that column of data.  I would go back to Power Query, edit that field to confirm everything is a numerical value.  In fact, once you confirm everything is numeric, I would change it to text and then do another step to change it back to numeric just to prove it is working.

mdaamirkhan's avatar
mdaamirkhan
Post Prodigy
5 years ago

there is no "blanks" or non-numeric data in any columns

  • collinq's avatar
    collinq
    Super User
    5 years ago

    Great mdaamirkhan ,

     

    And were you able to change the data type to text and back to numeric (or whatever you had)?

    • mdaamirkhan's avatar
      mdaamirkhan
      Post Prodigy
      5 years ago

      did that already but same issue 

      • v-kkf-msft's avatar
        v-kkf-msft
        Community Support
        5 years ago

        Hi mdaamirkhan ,

        When you select ALL, how do the visual in the figure below appear? 

        If Total end of contract is a measure, can you share its DAX formula? What is the relationship between Organisation, LoB and Total end of contract ?

         

        Best Regards,

        Winniz