Calculate the sum of a filtered measure

[BrianJ]

@jgriffit,

It would help if you could post your PBIX file to see if I’m missing anything here, but based on your description above I think all you need to do is create two more measures that calculate the sum of your [Levy=floor] and [Levy>floor] measures. Then you can drop those two new measures into cards to show the respective totals.

If your question is how to get the proper totals for each column in your table visual, please take a look at posts #11 and #14 in this topic, where I walked through this in detail with another member.

Capture date from Date Slicer

@axaeffect, One of the things I find most interesting about Power BI is that there are often many ways to accomplish the same result. Thus, while I’m sure there is a way to use dynamic segmentation to build this table, I would take a much simpler approach: create a measure (e.g., [Aging Category] ) that assigns the proper category from your range table based on the [Aging with Total] measure. You could do this with nested IF statements, but with four categories in your range table, this wil…

I hope this is helpful.

• Brian