Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure used in column

I have created a measure, when used in column, nothing was calculated. No column in the table is able to filter this measure. But my understanding is at least it will show the total amount of the measure, but instead nothing is shown. Hope to get ur help here.

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    I looked at your dax formula, I am not very clear about the structure of your table, you can try to delete the CALCULATE() function to see if it returns a null value, if it returns a null value, you need to check whether the RELATED() function can get the value of the corresponding table.
    For your question, can you provide us with the relationship between your tables and sample data so that we can better help you.

     

    Best Regards,

    Neeko Tang

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Neeko,

       

      Thanks for your help.

      The relationship of those tables are as in below pic, the SWH column in table "tFixed_Cost_Improver".

      I tried to remove CALCULATE, it returns total value of the measures. But I want the measure to be filtered by version column as well.