multiple values
2 Topics
Returning the larger value when error is Multiple results found
Hi all, I have two tables within PowerBI. Table 1 SOA which contains UserID, TeamID, SDate & EDate. Table 2 FLOW which contains UserID and TeamID --- I would like to return the EDate from SOA table. As the SOA table can have the same UserID and TeamID appear mulitple (but have a different SDate & EDate) I expect and recieve the error "A table of multiple values was supplied where a single value was expected" . (FLOWEDate = LOOKUPVALUE('SOA'[EDate],'SOA'[UserID],FLOW[UserID],'SOA'[TeamID],FLOW[TeamID])) Is there away I can perform the lookup but return the most recent EDate if it is not 31/12/2999 SOA Table: TeamID UserID SDate EDate FIN_EM_BEVRG FP99690 25/02/2020 02/03/2020 FIN_EM_BEVRG FP99690 27/10/2021 30/10/2021 FIN_EM_BEVRG FP99690 23/03/2023 31/12/2999 LCL_BEV_EMEA FP99690 22/11/2019 31/12/2999 LCL_BEV_FR FP99690 22/11/2019 31/12/2999 LCL_CCS_CENTRL GP65842 20/07/2020 10/08/2020Solved1.2KViews0likes4Comments
Percentage Calc Based on Three Values (Pass, Fail, Not Inspected)
Afternoon, I'm looking to put a Pass Rate Calc in my file that will allow for three values in a single column - Pass, Fail and Not Inspected. For example, lets say I have a sample of 150 cars; 50 of those cars passed inspection, 50 of those cars failed inspection and the remaining 50 were not inspected. As such, my pass rate on this is 50%. I have the below DAX, which I assume should work; Calc Inspection Result Pass Rate = DIVIDE( CALCULATE( COUNTROWS('EXTRACT') , 'EXTRACT'[Overall Result - Post Appeal] = "Pass" , COUNTROWS('EXTRACT') , 'EXTRACT'[Overall Result - Post Appeal] = "Fail") , CALCULATE( COUNTROWS('EXTRACT') , 'EXTRACT'[Overall Result - Post Appeal] = "Pass") , BLANK() ) But I keep getting the below error message - The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column. Any ideas?Solved1.2KViews0likes2Comments