Forum Discussion

rashidanwar's avatar
rashidanwar
Icon for Advocate II rankAdvocate II
2 years ago
Solved

How to Keep All Values of a Field When Using Measure on a Table Visual

I have a dataset in Power BI desktop. It contains 3 columns of data. title, approval_date, and amount. I have also a measure named approved_amount. The measure is summing the amount column where app...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rashidanwar 

     

    Glad to hear you solved the problem yourself! Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

     

    Best Regards

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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

rashidanwar , You can create a measure using ALL function which keeps all the values of title

 

approved_amount =
CALCULATE(
SUM('YourTableName'[amount]),
ALL('YourTableName'[approval_date])
)

  • rashidanwar's avatar
    rashidanwar
    Icon for Advocate II rankAdvocate II
    2 years ago

    Thank you bhanu_gautam for your response.
    ALL removes all the filter contexts so in our case we have outer filters as well coming from the Slicers. ALLSELECTED could do the job. I tried it but it doesn't work in my scenario. I am experiencing the same behaviour as  before using the ALLSELECTED.