Forum Discussion
Matrix table
Hi, I used matrix to make this table. Then I added 2 values from my data to "rows" and then drill down and thats how I have O&G as the section and borstar as the sub. Well for some reason O&G...
parry2k How do I do this? Where? Can you walk me through this please
parry2k
Super User
Super UserAnonymous here is example of one of the measure, instead of Duration field, use following Duration Measure and you will see in case of "O&G", it will give you blank() value, and you have to create similar measure for each and every Field you are using Value pane in matrix visual.
Duration Measure =
IF( NOT SELECTEDVALUE( Table[Active Projects] ) IN { "O&G", "ABC", "XYZ" } ),
SUM( Table[Duration]
)parry2k It's not working, is there another way to approach this?