Matrix not filtering properly because of measure

[Almaamari]

I have a table called ProcessLog, which tracks batches processed for migration and the various stages each batch has gone through or is currently undergoing. To visualize this data, I'm using a Matrix visual with BatchName as Rows and StageName as Columns. I've enabled the "Show items with no data" option for the StageName column to ensure all stages are displayed. Additionally, I've created a measure called "RefinedStatus" to replace blank statuses with "Not Started" while retaining other statuses. There's an Organization filter at the top, and the ProcessLog table includes an OrganizationId column as a foreign key to filter batches based on the selected organization.

RefinedStatus = IF(
ISBLANK(SELECTEDVALUE('ProcessLogging'[Status])),
"Not Started",
SELECTEDVALUE('ProcessLogging'[Status])
)

The issue I'm encountering is that when I select an organization without any associated batches, the matrix visual displays all batches with a status of "Not Started." I want the Matrix to first filter the batches based on the selected organization and then display the status based on the stage. 

I have pasted few snapshots to explain the scenario.

My Data Model.

[Almaamari]

Hi Wilson,

               Sorry i may not have explain my problem well. I want to show all the Batches by default even if it doesn't have any entry in the processLog table and the status as "not started" if a batch doesn't have any entry for the stage(s). Picture below.  Once filter is applied then i want to show only the batches related to that organization and then Show "Status" of a Batch for each stage. 

After using the suggested Dax, two things are happening . It's not showing all the batches if no filter is applied and it doesn't show the "Not Started" status for all the stages. 

[Wilson_]

Hi Almaamari,

Thanks for clarifying the issue. Oops, I did not see your data model originally. Can you please provide a sample pbix? (If you don't know how, please check the pinned thread in the forum.) I have an idea for a solution but I will need to tinker a bit with it first.

[Wilson_]

Hi Almaamari,

Try something like the below. The measure first checks to see whether the batch exists at all, regardless of status, before applying your logic.

RefinedStatus =
VAR Filtered =
CALCULATETABLE (
    'ProcessLogging',
    REMOVEFILTERS ( 'ProcessLogging'[Status]
)
VAR BatchExists = NOT ( ISEMPTY ( Filtered ) )
VAR Result =
IF ( 
    BatchExists, 
    COALESCE ( SELECTEDVALUE ( 'ProcessLogging'[Status] ), "Not Started" )
)

RETURN Result

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)