Forum Discussion

elliottcarver's avatar
elliottcarver
Frequent Visitor
6 years ago

Complex DAX Calculation - Event Log Cycle Times for Process Mining

Trying to create a model for cycle-time reporting that allows a report-user to know how often the time between any two steps met a variable target.   I want report users to input the following vari...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Elliot, 

 

Maybe my explanation wasn't too good either.

 

But you did proof my point. By hardcoding "   'Change Log Entry - Process Mining Entry'[Process Mining Step Index]=0)" instead of 

"= SELECTEDVALUE('Step A'[Step ID)" you influenced the operation at the time the table is created and getting the desired result.

Filters (slicers or otherwise) are not taken into account when creating a table. By the way, the same applies to a calculated column.

 

So the only way to have a dynamic user interaction is via measures in a visual.  Unless you to use parameters that are applied during the data load. 

 

I tried to find an article on this behaviour, but I could not find it immediately. But there are some topics on the forum where the same 'problem' is described 
https://community.powerbi.com/t5/Desktop/Pass-Filter-context-of-measure-into-the-calculated-column-in-DAX/td-p/422553

https://community.powerbi.com/t5/Desktop/Dynamic-Filtering-of-derived-DAX-table-based-on-the-filters/td-p/222856

 

Hope this helps a bit

 

jan 

 

elliottcarver's avatar
elliottcarver
Frequent Visitor
6 years ago

This is really helpful feedback Jan - thanks so much for your help 🙂

 

So, is there any way for me to measure the time between any Step A and any Step B using the same dataset?

Or should I make this report a template and create several copies of it with the same parameters?

There's so many AB Sets I'm interested in analyzing that I'm a little worried about overloading my BI Service with requests.