Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Anonymous , 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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thank you amitchandak for your reply. I can see how this would work but currently I cannot get it to correctly identify what is selected in both slicers and what is not. I believe the issue is within here somewhere:

VAR InsurerInMarket =
    IF(
        ISBLANK(SelectedMarket),
        BLANK(),
        IF(
            CALCULATE(COUNTROWS('OneApp Selection'), FILTER('OneApp Selection', 'OneApp Selection'[Insurer List] = SelectedInsurer && 'OneApp Selection'[Market List] = SelectedMarket)) > 0,
            "Dupe",
            "Single"
        )
    )