Forum Discussion

josevaras's avatar
josevaras
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Remove 100%

Hello, thank you in advance for your help.  I have the measure below that I am using in a matrix. When I bring the measure in I change it to "% of columns" and it works fine. The issue (my que...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
6 years ago

Hey josevaras ,

 

you might check this measure, I have rewritten the OR filter a little, this is more than a habit than solving your problem. The IF(...) is the essential part 🙂

 

messure = 
var _checkValue =
	CALCULATE(
		SUM('Data TBL'[Total] ) ,
		'Data TBL'[SKU Level] IN  {"Product 1" , "Product 2"}
	)
return
IF(_checkValue = 1 , BLANK() , _checkValue)

Hopefully, this provides what you are looking for.

 

Regards,

Tom