Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Help in Slicer Conditional Measure

    Silver Contributor
    Posted Dec 14, 2022 08:20 AM
    Hi , I have a requirement where i have two slicer - one is monthly and other is Market, where i have to make a measure to show data in a card based on the selection from both the slicers. For example - if i have selected Sep-2022, and Market EU then EU = 22.45% shall come if selected NA - 22.55%, GM - 23.3% like that it should come and if i select the different month then EU/GM/NA value shall change.

    if(SELECTEDVALUE('Calendar'[Month Year]) = "Sep-2022" , if( SELECTEDVALUE('myWizard Project'[Market 2]) = "EU", "26.82%",if(SELECTEDVALUE('myWizard Project'[Market 2]) = "NA", "34.12%", IF(SELECTEDVALUE('myWizard Project'[Market 2]) = "GM", "22.50%")))), "29.49%")
    but this formula gives blank.

    Can anyone please help?


    ------------------------------
    Krishna Nandan
    SME
    Bangalore
    ------------------------------


  • 2.  RE: Help in Slicer Conditional Measure

    Posted Dec 14, 2022 11:44 AM

    Veja se dá certo. Se não der, envia seu pbix por favor. Pode ser com dados fictícios.

    Medida =
    VAR Var1 = SELECTEDVALUE ( 'Calendar'[Month Year] )
    VAR Var2 = SELECTEDVALUE ( 'myWizard Project'[Market 2] )
    RETURN
        SWITCH (
            TRUE (),
            Var1 = "Sep-2022" && Var2 = "EU", "26.82%",
            Var1 = "Sep-2022" && Var2 = "NA", "34.12%",
            Var1 = "Sep-2022" && Var2 = "GM", "22.50%",
            "29.49%"
        )​


    ------------------------------
    Vilmar Santos
    ------------------------------