Forum Discussion

Samba777's avatar
Samba777
Frequent Visitor
3 years ago
Solved

Need Help: Remove column subtotals from power bi matrix visual

Hi Folks,   Below is the matric visual, one column contanits Efforts  and other one is Avergae of sprint numbers. when i added those two columns into Values section, I am getting below output as p...
Need Help
  • Samba777's avatar
    Samba777
    3 years ago

    It works Perfectly !! thanks

Barthel's avatar
Barthel
Icon for Solution Sage rankSolution Sage
3 years ago

Hey Samba777, 

So you only want to show the measure for the total, i.e. when the sprint is not in scope. You can use the ISINSCOPE function for this. Try someting like this:

Measure =
IF ( NOT ISINSCOPE ( 'Table'[Sprint] ), [AverageofLast5sprint] )
Samba777's avatar
Samba777
Frequent Visitor
3 years ago

It works Perfectly !! thanks