topic Re: Calculate sum based on two slicer excluding the value selected in first slicer in DAX Commands and Tips

Calculate sum based on two slicer excluding the value selected in first slicer

denengland — Wed, 12 Apr 2023 19:54:39 GMT

Hi there,

I am trying to create measures which will calculate sum of drug, and the sum of all other drugs belonging to the category which the selected drugs belong to.

I am new to dax, but i am trying to achieve this using two slicers

Re: Calculate sum based on two slicer excluding the value selected in first slicer

Wilson_ — Thu, 13 Apr 2023 00:32:09 GMT

Hello denengland,

See this sample pbix file. Not sure where the second slicer comes into play here but maybe you need it for something else.

For what it's worth, SQLBI is a fantastic Power BI resource for everybody, especially beginners.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

Re: Calculate sum based on two slicer excluding the value selected in first slicer

denengland — Thu, 13 Apr 2023 06:11:40 GMT

Wilson, thank you for the solving this question. Your solution works perfectly. This is exaclty the response I was looking for. I will check out the SQLBI resource per your suggestion. I greatly appreciate your help!!!