Count of Upper Hierarchy

[I_LOVE_POWER_BI]

Hi guys,

What I need is the following count highlighted in yellow as a new column:

[dhruvinushah · Accepted solution]

Hi @I_LOVE_POWER_BI , 
If your requirement is to get the Lowest price from the different material types in the Material master then try this formula:

LowestPrice = 
var Lowest = MIN('MaterialTable'[Price])

var SummarizedLowest = MINX(SUMMARIZE('MaterialTable',[MaterialMaster],[MaterialType]), Lowest)

return
SummarizedLowest

Hope this helps.