Hello Guys, am new in dax and would like someone to help me how to sum up a particular result in a DAX code. The DAX code i wrote is as follows:
Column = CALCULATE( VALUES(Customer[City]),
//COUNTROWS(Customer),
//VAR SD = 1
FILTER(
ALL(Customer[City]),
Customer[City]="San Diego")
the result i got from the Code is perfect which is San Diego now i want to count the number of san diego result and be displayed on the screen after running the code. Can someone possibly help me out of this mess.
Thanks
Column = CALCULATE( VALUES(Customer[City]),
//COUNTROWS(Customer),
//VAR SD = 1
FILTER(
ALL(Customer[City]),
Customer[City]="San Diego")
the result i got from the Code is perfect which is San Diego now i want to count the number of san diego result and be displayed on the screen after running the code. Can someone possibly help me out of this mess.
Thanks