Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anand_developer
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
Eric_Zhang
Employee
Employee

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

 

View solution in original post

2 REPLIES 2
Eric_Zhang
Employee
Employee

@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
Not applicable

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.