show developer availability based on condition (show in table or matrix or visual)

Question

Dear Helper&nbsp;&nbsp; please kindly read the complete data. kindly share the powerbi file&nbsp;table A&nbsp;developer projectstatus&nbsp;&nbsp;&nbsp; &nbsp;a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; fsd&nbsp; &nbsp;b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; uat&nbsp; &nbsp;c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; hypercare&nbsp; &nbsp;d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dev&nbsp; &nbsp;e&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; devloper allocated&nbsp; &nbsp;f&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;live&nbsp;table Bdeveloper&nbsp; &nbsp; teammanger&nbsp;&nbsp;&nbsp; a&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subbu&nbsp; b&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subbu&nbsp; c&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subbu&nbsp; d&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subbu&nbsp; e&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subbu&nbsp; f&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; subbu&nbsp; g&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;subbu&nbsp;&nbsp; h&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;subbucondition1. join the two tables2. show developer who are not in fsd,uat,live3. show developer who doesnt have project statusregardsrasi&nbsp;&nbsp;&nbsp;

ddpl · Accepted Answer

pasupathi&nbsp;&nbsp;2. show developer who are not in fsd,uat,live&nbsp;Create measure as per below:Condition&nbsp;2&nbsp;=CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;MAX&nbsp;(&nbsp;TableA[project&nbsp;status]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;TableA[project&nbsp;status]&nbsp;&lt;&gt;&nbsp;"fsd",&nbsp;&nbsp;&nbsp;&nbsp;TableA[project&nbsp;status]&nbsp;&lt;&gt;&nbsp;"uat",&nbsp;&nbsp;&nbsp;&nbsp;TableA[project&nbsp;status]&nbsp;&lt;&gt;&nbsp;"live")&nbsp;3. show developer who doesnt have project statusCreate column in TableB as per below&nbsp;project_status = LOOKUPVALUE(TableA[project status],TableA[developer],TableB[developer])then filter by slecting blank as per below snap&nbsp;&nbsp;&nbsp;

Forum Discussion

show developer availability based on condition (show in table or matrix or visual)

1 Reply

Related content

ParaTimeLine not available

custom visual development

Rank with conditions

GA availability for streaming connector virtual network

Conditional Formatting using DAX