Forum Discussion
Excluding Selected Data in Graphs
I guys, I am looking for some help with a rather specific issue I have been working on for the last couple days. I unforunately cannot link the Report as my company PC prevents this in any form. I w...
amitchandak
Super User
Super UserAnonymous , Try like
Desired Frequency =
VAR SelectedInsurer = SELECTEDVALUE('Selection'[Insurer List])
VAR SelectedMarket = SELECTEDVALUE('Selection'[Market List])
VAR InsurerInMarket =
IF(
ISBLANK(SelectedMarket),
BLANK(),
IF(
CALCULATE(COUNTROWS('Selection'), FILTER('Selection', 'Selection'[Insurer List] = SelectedInsurer && 'Selection'[Market List] = SelectedMarket)) > 0,
"Dupe",
"Single"
)
)
VAR InsurerData =
IF(
InsurerInMarket = "Dupe",
BLANK(),
CALCULATE(AVERAGE('Data'[Frequency]), 'Data'[Peer & Market Choice] = SelectedInsurer)
)
VAR MarketData =
IF(
InsurerInMarket = "Single",
CALCULATE(AVERAGE('Data'[Frequency]), 'Data'[Peer & Market Choice] = SelectedMarket),
BLANK()
)
RETURN
InsurerData + MarketData