3 Matching Annotations
  1. Last 7 days
  2. learn.microsoft.com learn.microsoft.com
    Perform context transition - Training
    1
    1. ebeeman 13 Aug 2024
      VALUES('Sales Territory'[Country])

      Why does this need VALUES? Does it need it?

      "Values(): Duplicate values are removed and only unique values are returned"

    Visit annotations in context

    Annotators

    URL

    learn.microsoft.com/en-us/training/modules/dax-power-bi-modify-filter/5-context-transition
  3. Jul 2023
  4. learn.microsoft.com learn.microsoft.com
    Perform context transition - Training
    2
    1. ebeeman 16 Jul 2023
      Sales Commission

      Why is this iterated by Region? Just for examples sake? It could iterate per Country just as well?

    2. ebeeman 14 Jul 2023
      [Revenue]

      If I remember correctly, measures are always handled as if whatever they include are wrapped in a calculate(). So even if [Revenue] would contain sum(...), it would work.

    Visit annotations in context

    Annotators

    URL

    learn.microsoft.com/en-us/training/modules/dax-power-bi-modify-filter/5-context-transition