Forum Discussion

MandyL's avatar
MandyL
Icon for Helper I rankHelper I
3 years ago

How to include the filter out data on the DAX Calculate function

Hi Team, There are three pages on the PBI report, each page showing the project status. If we filtered the Project_Status=”Win” on the first page, may I know how to change the calculate column (Win...
@Dax help
PurpleGate's avatar
PurpleGate
Icon for Resolver III rankResolver III
3 years ago

Hi,

 

You could try change ALL to ALLSELECTED 

 

Win%=
VAR Sales_WIN= CALCULATE( ‘Project’[Sales Amount],  Filter (ALLSELECTED (‘Project’), [Project_Status]=”Win”))
VAR Sales_Closed= CALCULATE( ‘Project’[Sales Amount],  Filter (ALLSELECTED(‘Project’), [Project_Status]=”Closed”))
VAR Sales_Pending= CALCULATE( ‘Project’[Sales Amount],  Filter (ALLSELECTED(‘Project’), [Project_Status]=”Pending”))

Return
Sales_WIN/(Sales_WIN+Sales_Closed+Sales_Pending)