Forum Discussion
Using a dimension to filter a measure
Hi everyone, I am trying to slice a measure below based on the category . The measure is Total Amount (works perfectly) and it calculates (Running total) "Total Amount" for an item and assign...
Hi Thanks for suggestion
below is dropbox link to the file
https://www.dropbox.com/s/cf6ho1p0hrxia3m/Final.pbix?dl=0
- vanessafvg
Community Champion
will have a look at bit later!
- vanessafvg
I am still not 100% clear on what your intended behaviour is. But what I can see in your total code is that you are combining categories in your total As per the screenshot provided.
I have add a new measure called total new to filter through the category to bring back what is shown in the table
If your intention is indeed to mix categories then filtering on A will remove the B from the equation so What is the purpose of filtering?
please see file attached.
