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 

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()
)
  • Kumshan450's avatar
    Kumshan450
    Helper III
    6 years ago

    Thank you very much.