Forum Discussion

Kumshan450's avatar
Kumshan450
Helper III
6 years ago
Solved

Context Transition Issue

In the below image, you can see that there are different results for the Fabrikam brand.      The following are the dax measures.  Fabrikam Sales= sumx( filter(Sales, Related(Product[Bran...
Need Help
  • az38's avatar
    az38
    6 years ago

    Kumshan450 

    So far, I localize a diffrenece here

az38's avatar
az38
Community Champion
6 years ago

Kumshan450 

there is no access to your data sample, please, check access policy

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Kumshan450 

      So far, I localize a diffrenece here

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Kumshan450 

        from the first sight I see two options here

        1. a complex measure like

        Sales by Brand = calculate([Sales Amount],
    ALLEXCEPT(Sales, 'Product'[Brand]))

        2. a fabrikam Measure

        FabrikamSales = 
IF(
SELECTEDVALUE('Product'[Brand])="Fabrikam", 
calculate([Sales Amount], 'Product'[Brand]="Fabrikam"), 
BLANK()
)