Conditional SUM
I used the following DAX to return total "Approved" amounts across all datanameshorts in my dfact table. When datanameshort is either "SBG" or "SBG10" the total of "Approved" and "Paid" amounts must be returned instead. As datanameshort is a column I needed to use selectedvalue to get a single value out of all values in the column and looks like that makes the condition to be always False (only else part gets executed) ApprovedAmount = IF ( CONTAINSSTRING(SELECTEDVALUE(DFACT[DATANAMESHORT]), "SBG"), CALCULATE(SUM(DFACT[AMOUNT]), FILTER(DFACT, CONTAINSSTRING(DFACT[DATANAMESHORT],"SBG") && DFACT[STATUS] IN {"Approved","Paid"} && DFACT[GEONAME] <> BLANK())), CALCULATE(SUM(DFACT[AMOUNT]), FILTER(DFACT, DFACT[STATUS] = "Approved"))) Does anyone have any idea how to fix this. a screenshot of the dfact table is added
Calculate with multiple filters
Hi everyone, I am trying to calculate a percentage here by using the CALCULATE function with multiple filters. Here is the dax code that I have written. This measure works as it should, but it takes time to load. I am wondering if there is another way of writing the DAX for better performance? % of hires within 15 workdays = VAR NoHiresWithin15WorkDays = CALCULATE(countrows(filter(Request,Request[Hired within 15 Workdays]="Yes")),FILTER(REQUEST, Request[AcceptanceDt]<>BLANK() && [Candidate Confirmed Date]<>BLANK() && Request[RPI2 - DateFlag by RequestID]=tRUE() && [Feedback Workdays by requestID]<=5)) var requestidcount = CALCULATE(COUNT(Request[RequestID]), FILTER(REQUEST, Request[AcceptanceDt]<>BLANK() && [Candidate Confirmed Date]<>BLANK() && Request[RPI2 - DateFlag by RequestID]=tRUE() && [Feedback Workdays by requestID]<=5)) RETURN NoHiresWithin15WorkDays/requestidcount Thank you in advance!
