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...
Anonymous 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?
Anonymous not sure what you mean by it is not working? Elaborate? If you can send sample pbix file, will help you to get the solution.