Forum Discussion

abbytank's avatar
abbytank
Frequent Visitor
3 years ago
Solved

Dax Calculate Function

I have been wrestling to understand how logically the following to statements or (measures) are providing different results.    Sales PCT_1 =     var current_sales = sumx(sales, Sales[Quantity]*Sa...
  • MattAllington's avatar
    MattAllington
    3 years ago

    Variables are not variable, they are constant.

     

    You cannot alter the value of a variable once it has been assigned. Therefore this line of code does not change the value of the variable

    var all_sales = calculate(current_sales,all('Product Category'[Category]))

MattAllington's avatar
MattAllington
Community Champion
3 years ago

Variables are not variable, they are constant.

 

You cannot alter the value of a variable once it has been assigned. Therefore this line of code does not change the value of the variable

var all_sales = calculate(current_sales,all('Product Category'[Category]))