Forum Discussion

Joe_100's avatar
Joe_100
Helper I
7 years ago

Matrix remove totals(first value) from text

Hi all,   I am trying to create a matrix that will have some text values in the columns. Unfortunetaly Power Bi assumes that i want the first value as subtotal or grand total.   I almost got it ...
Need Help
AnthonyTilley's avatar
AnthonyTilley
Solution Sage
7 years ago

i hope i understood what you where looking for 

 

use the hasonefilter function

 

i do not have your source data to replicate your measure but in the example below 

i have a text colunm that will say Project + project number as text but only in the subrows nothing shows in subtotals or grand totals as these are replaced with blank 

 

Measure = 

Var o = "PROJECT" & MAX('Table'[PROJECT])
var ret = if(HASONEFILTER('Table'[PROJECT]),o,blank())
return ret

 var o can be replaced with what ever you want to appear in your table 

var ret then checks if the value has only one filter for the project colunm