Matrix with its own value when I expand to the next level

[ChristoNindyo]

Hello,

I want to ask how do I calculate Stores below. I want it has its own value when I expand to the next level (the manager name)

This is the measure I used :

AM_STORE_COUNT3 =
CALCULATE(
DISTINCTCOUNT(CUST_UNI[LEGAL_NAME]),
CUST_UNI[BANNER_NAME] = SELECTEDVALUE(IRI_STORE_COMBINED[BANNER_NAME]
))

Notes: LEGAL_NAME is the store name

Thank you !

[amitchandak · Accepted solution]

@ChristoNindyo ,  Your formula seem fine to me, you can use removefilters

AM_STORE_COUNT3 =
CALCULATE(
DISTINCTCOUNT(CUST_UNI[LEGAL_NAME]),
removefilters(CUST_UNI[BANNER_NAME])
))

or

AM_STORE_COUNT3 =
CALCULATE(
DISTINCTCOUNT(CUST_UNI[LEGAL_NAME]),
filter(allselected(CUST_UNI) , CUST_UNI[BANNER_NAME] = max(CUST_UNI[BANNER_NAME])
))

[Ritaf1983 · Accepted solution]

Hi @ChristoNindyo 
It seems that you are using disconnected tables...
if the tables are with relationships the measure  should be just :
DISTINCTCOUNT(CUST_UNI[LEGAL_NAME])

if not you can try something like :
if (CUST_UNI[BANNER_NAME] = max(IRI_STORE_COMBINED[BANNER_NAME],

DISTINCTCOUNT(CUST_UNI[LEGAL_NAME]),"")

for more detailed and accurate suggestion 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[amitchandak · Accepted solution]

@ChristoNindyo ,  Your formula seem fine to me, you can use removefilters

AM_STORE_COUNT3 =
CALCULATE(
DISTINCTCOUNT(CUST_UNI[LEGAL_NAME]),
removefilters(CUST_UNI[BANNER_NAME])
))

or

AM_STORE_COUNT3 =
CALCULATE(
DISTINCTCOUNT(CUST_UNI[LEGAL_NAME]),
filter(allselected(CUST_UNI) , CUST_UNI[BANNER_NAME] = max(CUST_UNI[BANNER_NAME])
))