present the value in a non-standard way

[Kris48]

Please help me to present the value in a non-standard way
Link PBIX: https://drive.google.com/file/d/1fJKwtkJ3NtRTkVnW-SX_C3sg4t3ByiNY/view?usp=sharing 

[SachinNandanwar]

My attempt

PBI File location : https://easyupload.io/2kg3k7

[lbendlin]

Will SubCat always be the last element in the hierarchy?

Units_ = 
var s = sum('Table'[Units])
var sc = values('Table'[SubCat])
var a = CALCULATETABLE('Table',REMOVEFILTERS('Table'[SubCat]))
var b = SUMMARIZE(a,[SubCat],"sm",sum('Table'[Units]))
var t = SELECTCOLUMNS(TOPN(1,b),[SubCat])
return if(sumx(b,[sm])=s*COUNTROWS(b),if(t=sc,s,0),s)

[Kris48]

Thank you very much! You helped me a lot!

I have two more requests. If you don't find time for it, I will accept your earlier answer anyway, but I will be very grateful if you can help me 🙂

[lbendlin · Accepted solution]

For your first ask you need to materialize the measure.

I don't understand the second ask.