Forum Discussion
Filtering A Visual Without Applying Filters
Hello, I am trying to create a Comparison View between two sides, and am having trouble getting a common table to reference each side of the comparison. As you can see below, I have selected a total...
Could you provide the calculation for [Net Sales] as well? Still, pbix file would be the best option here.
And small off-topic here. Try not to use FILTER function within CALCULATE, especially when you pass entire table as an argument, it's a performance killer.
PawelWrona Net Sales is:
Net Sales = CALCULATE(SUM(FACT_SALES[Value]),FACT_SALES[Attribute]="Net")
And understandable if you may need the model to troubleshoot this. Appreciate the headsup on the Filter function.
Thank you