Show All Root Causes for Orders with Step 4 in Selected Month
Hi there, I have a table 'OrderPlace', which contains the place (or status) of every order, along with a root cause why a certain order is too late: the "Actual Date" column is connected to a date table. I have a page called 'root causes step 1-4', which should summarize all root causes of step 1 to 4. This page has a slicer on DimDate[Month]. When I count all root causes and the slicer is set to 'October', I only see the root causes that fell in October: Count RC is just a measure that counts all root causes: COUNT(OrderPlace[RootCause]) This is not what I'm trying to achieve. In this example, "Item not yet available" and "Problem with Paypal" should be visible here aswell, because they all contribute to why the orders were too late in the postal office in October. In other words: I want to see all root causes of the orders where step 4 fell in the month October, not just the root causes that happened in October. Thanks in advance
