cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anand_developer Frequent Visitor
Frequent Visitor

showing wrong value instead of Default Value from Slicer

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"))
)

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: showing wrong value instead of Default Value from Slicer

@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"
        )
    )
)

 

2 REPLIES 2
Moderator Eric_Zhang
Moderator

Re: showing wrong value instead of Default Value from Slicer

@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"
        )
    )
)

 

saurabh_2018 Frequent Visitor
Frequent Visitor

Re: showing wrong value instead of Default Value from Slicer

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

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 55 members 1,026 guests
Please welcome our newest community members: