Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Check if only slicer is selected

    Posted Dec 19, 2022 08:12 AM
    Hello,
    I'm struggling with following topic.
    I need to identify if value in slicer is selected but don't look at table grouping.

    For my calculation I need to take Measure [Wo/Type] only when slicer is set to ALL, but when Slicer has any value chosen I need to use [W/Type] measure.


    Unfortunately ISFILTERED() function is used for calculation when table values are grouped by the same filed as field used in slicer.
    Here [__IsTypeFiltered = ISFILTERED('Table'[TYPE])]

    Do you have any idea how to handle with that

    ------------------------------
    Jaroslaw Danda
    ------------------------------


  • 2.  RE: Check if only slicer is selected

    Posted Dec 19, 2022 11:03 PM
      |   view attached
    Veja se o anexo ajuda.

    Foi criado uma segunda tabela dimensão para Cidade.

      • A [Medida] vai mudar para [Venda] somente quando a segmentação de dados Cidade estiver definida como TODAS.
      • Quando a segmentação de dados tiver algum valor escolhido, vai mudar para [Qtde].


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

      Attachment(s)

      pbix
      Test.pbix   79 KB 1 version


    • 3.  RE: Check if only slicer is selected

      Posted Dec 21, 2022 02:56 AM
      Este es un recorrido muy inteligente que (lo que es más importante) funciona.
      Muchas gracias Vilmar

      ------------------------------
      Jaroslaw Danda
      ------------------------------