Forum Discussion
Blank & Filter
Hello - I have this simple measure below. However, the measure is partly based on a field that would normally not show up (or show as blank) when filtered by the "actual close" date. The reason why is because the "actual close" date filter actually filters out everything except for "closed" opportunities. However, I need to show my win rate on the same page as my won/lost information, and this calculation is part of that.
I'm pretty sure there is a way to have this formula ignore any filters...but not sure how?
Hi Anonymous ,
Try modifying your DAX as below:
WinRate = CALCULATE(DIVIDE([Opps had an Opportunity], [Total Deals], 0), ALL(Tablename))In the above dax replace Tablename with your table-name.Thanks,Pragati
3 Replies
- Pragati11
Super User
Hi Anonymous ,
Try modifying your DAX as below:
WinRate = CALCULATE(DIVIDE([Opps had an Opportunity], [Total Deals], 0), ALL(Tablename))In the above dax replace Tablename with your table-name.Thanks,PragatiPragati11 That worked!....but it exposed a different issue when I put it into a chart.
It apparently created a barcode! : ) I did create a relationship (inactive) between the date table and the "actual close" date. And I tried a USERELATIONSHIP formula in the measure you helped me with. It did not show any errors with the formula but clearly it is not working. : (
As just a card visual it works fine....just not when put into a visual with dates.
- Pragati11
Hi Anonymous ,
If you understand the dax expression below:
WinRate = CALCULATE(DIVIDE([Opps had an Opportunity], [Total Deals], 0), ALL(Tablename))
ALL avoids any external filters being applied to your dax expression.
If you are planning to move the WinRate dax to a bar chart, try creating a new measure as follows:
WinRateNew = CALCULATE(DIVIDE([Opps had an Opportunity], [Total Deals], 0), ALLSELECTED(Tablename))
Thanks,
Pragati