Hide total in a matrice

[PierreCA]

Hello, 

I use a mactrice to report textual data. 

As depicted in the picuture, I dont' want a "sum" of the values by each Entité or date.  

So far, I removed subtotals options, but with very limited effect. 

I want the values to stay with its line and stay invisible otherwise. 

How can I set that?

[Greg_Deckler]

@PierreCA One option would be to use HASONEVALUE in a measure that is used to conditionally format the text to the background color if there is not one value and if there is display it in white.

[PierreCA]

Hello @Greg_Deckler ,

Thanks for your swift response. 

Do you have an exemple of your proposition?

[PierreCA · Accepted solution]

After many experimentations, the best solution was to use Inscope to test whether or not the returned value is at the right hierachy level. If not, the formula returns nothing in the matrix, as expected.


Whitout Inscope

With Inscope

datesRetournee = 

VAR idNotification = SELECTEDVALUE (Notification[Id])
VAR dateNotificationTrouvee = 

        CALCULATE( IF(ISINSCOPE(Notification[Id]), MINX( FILTER(Notification, Notification[Id]=idNotification), Notification[dateNotification])))

RETURN

dateNotificationTrouvee