showing wrong value instead of Default Value from Slicer

[Anand_developer]

Hi Genius ,

Question:

if dont choose any option from my slicer. i have set my default currency value as EURO but its showing USD vale is my default.

My table : 

currency_id       Currency

1                        USD

2                        EURO

3                        Aop Comparable

my measure code is :

Selected Currency = MIN('Currency Table'[currency_id])

selection currency = IF (HASONEVALUE('Currency Table'[Currency]),VALUES('Currency Table'[Currency]))

SalesTo Thirds = switch([selected currency],1,calculate([CYACTUALUSDSCALEPERIOD],filter(vPMA_NAM_SalesReport,vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7]="Sales to Thirds"))
,2,calculate([CYACTUALEURSCALEPERIOD],filter(vPMA_NAM_SalesReport,vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7]="Sales to Thirds"))
,3,calculate([CYACTUALAOPCOMPARABLESCALEPERIOD],filter(vPMA_NAM_SalesReport,vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7]="Sales to Thirds"))
,calculate([CYACTUALEURSCALEPERIOD],filter(vPMA_NAM_SalesReport,vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7]="Sales to Thirds"))
)

[Eric_Zhang · Accepted solution]

@Anand_developer

The measure below in your case would return 1(USD) when no currency selected.

Selected Currency = MIN('Currency Table'[currency_id])

Which means, the SWTICH would always go to option 1 if no selection on the slicer.

SalesTo Thirds =
SWITCH (
    [selected currency],
    1, CALCULATE (
        [CYACTUALUSDSCALEPERIOD],
        FILTER (
            vPMA_NAM_SalesReport,
            vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7] = "Sales to Thirds"
        )
    ),
    2, CALCULATE (
        [CYACTUALEURSCALEPERIOD],
        FILTER (
            vPMA_NAM_SalesReport,
            vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7] = "Sales to Thirds"
        )
    ),
    3, CALCULATE (
        [CYACTUALAOPCOMPARABLESCALEPERIOD],
        FILTER (
            vPMA_NAM_SalesReport,
            vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7] = "Sales to Thirds"
        )
    ),
    CALCULATE (
        [CYACTUALEURSCALEPERIOD],
        FILTER (
            vPMA_NAM_SalesReport,
            vPMA_NAM_SalesReport[PMA Adjusted Hierarchy Level7] = "Sales to Thirds"
        )
    )
)

[Anonymous]

I'm facing the same issue, how did you resolve it?