Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

LOD? DAX?

Is there a way to get the value of On Hand to be 32 using a calculated field??  My goal is to get the correct value which is 32 without using Average for the component 12P9813X032. But the value is s...
Need Help
Show and Tell
  • selimovd's avatar
    selimovd
    4 years ago

    Hey Anonymous ,

     

    I think I found the reason. You added the formula as calculated column, but you have to add it as measure:

     

    Then the result is correct:

     

    To understand the difference, a calculated column is just a new column in the table. In your case you added a new column that returned for every row the average of

    tableforqty[ONHAND_QTY] what is for each row the same value as the column tableforqty[ONHAND_QTY]. When you put that calculated column in the matrix the visual was summing up the averages, what was equal to the total.
     
    If you use a measure it will always be calculated on the fly and in the context that you are using it. So if you put the measure in the matrix, it will calculate the average for each Component_Code and also for the total.
     
    You can see the difference also by the logo. The calculated column [On Hand Average] has the icon of a table, the measure [On Hand Average as Measure] has the icon of a measure.
     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

When adding Hands on column to your table visual right click and you will see many operations such as SUM, Average etc etc. Use average. If it does'nt work please explain a bit more so that I can fully understand what you are doing.

 

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

Appreciate your Kudos!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    the on hand column is adding all the rows that is why it's showing 1280, is there a way to show 32  for the on hand sum column?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

       

       Can you access this for the On_hand Column ??? there select Average from this dropdown.

       

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

      Appreciate your Kudos!!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        hi Anonymous 

        Can i use it for another calculated field?

         

        like  how do i do,

        ON_HAND - REQUIRED.QUANTITY 

        should be 32 - 40 , desired outout = -8

         

         

        if on_hand correct value is just from the dropdown but not came from the calculated column