Forum Discussion
Solved
Display multiple values in same column/row in matrix
Hi I want do display all events in categories (Cat) in a timeline matrix. I have 7 Cat (A - G) and Cat A can have multiple events during one day. The model is based on one fact table (FTT) and a...
RedDwarf_803, Thanks for the .pbix file. Give this a shot and let me know if it's what you're after.
Test time 2 = VAR time = SELECTEDVALUE ( TT[Time] ) VAR startTime = CALCULATE ( MIN ( FTT[Start time] ), REMOVEFILTERS ( TT ), FTT[End time] >= time ) VAR endTime = CALCULATE ( MAX ( FTT[End time] ), REMOVEFILTERS ( TT ), FTT[Start time] <= time ) RETURN IF ( time >= startTime && time <= endTime, 1, 0 )If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.
Hey RedDwarf_803, thanks for the screenshot and descriptions. Could you provide the example .pbix file (here's how)? Happy to help.
RedDwarf_803, Thanks for the .pbix file. Give this a shot and let me know if it's what you're after.
Test time 2 = VAR time = SELECTEDVALUE ( TT[Time] ) VAR startTime = CALCULATE ( MIN ( FTT[Start time] ), REMOVEFILTERS ( TT ), FTT[End time] >= time ) VAR endTime = CALCULATE ( MAX ( FTT[End time] ), REMOVEFILTERS ( TT ), FTT[Start time] <= time ) RETURN IF ( time >= startTime && time <= endTime, 1, 0 )If this is enough to get you going please consider liking this reply and choosing it as the solution. Otherwise, I'm happy to help further.
Thanks Madison. Your DAX works fine