How to force countax to calculate by the last level of hierarchy without need to showing it

[foks]

Hi all,

I got problem with DAX measure and I don't know what I'm doing wrong...

I have 3 - level hierarchy 

The problem is that my COUNTAX measure is working ok when I'm listing all three levels in the matrix. But it's showing wrong result when I delete the last level (I don't want it to  be shown). 

I don't have any idea what is wrong here. The DAX measure is: 

Count = COUNTAX('Hierarchy',if(isblank([Measure1])&&[Measure2]>=6,1,blank()))

Measure1 and Measure2 make sense only when calculated by the last level of hierarchy.

How I can force my count to calculate by the last level but without showing it on the report?

[amitchandak]

@foks , Not very clear

refer

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/

https://www.sqlbi.com/articles/clever-hierarchy-handling-in-dax/

[Anonymous]

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490