Matrix - Display row data only on top level of hierarchy power bi

MKPBI_2805 — Fri, 25 Jun 2021 21:42:11 GMT

I have 3 tables like below

SALES
ORD_NBR	ACCOUNT_TYPE_A	ACCOUNT_TYPE_B	REVENUE
O1	A1		10
O2	A1	B1	11
O3		B2	12
O4	A2	B1	13
O5	A2	B3	14

ACCOUNT_A
ACCOUNT_ID	ACCOUNT_NAME	THRESHOLD_VALUE
A1	APPLE	100
A2	HP	90
A3	DELL	80
A4	LENOVO	70

ACCOUNT_B
ACCOUNT_ID	ACCOUNT_NAME
B1	FACEBOOK
B2	MICROSOFT
B3	AMAZON

POWERBI MATRIX

ACCOUNT_TYPE_A	ACCOUNT_TYPE_B	REVENUE	ACCOUNT_TYPE_A_THRESHOLD
APPLE		21	100
	FACEBOOK	11
	MICROSOFT
	AMAZON
HP		14	90
	FACEBOOK
	MICROSOFT	14
	AMAZON
DELL			80
	FACEBOOK
	MICROSOFT
	AMAZON

I am using THRESHOLD MEASURES as below

IF(ISINSCOPE('ACCOUNT_B'[ACCOUNT_ID]) ,BLANK(),SUM('ACCOUNT_A'[THRESHOLD_VALUE]))

I need to get rid of values in the Red color.

Re: Matrix - Display row data only on top level of hierarchy power bi

dedelman_clng — Thu, 01 Jul 2021 18:29:58 GMT

Hi MKPBI_2805 -

Your required output doesn't seem to match your data, but to get rid of rows that have BLANK for revenue, go the the Filters Pane and select where REVENUE is not blank.

Hope this helps

David

topic Re: Matrix - Display row data only on top level of hierarchy power bi in DAX Commands and Tips

Matrix - Display row data only on top level of hierarchy power bi

Re: Matrix - Display row data only on top level of hierarchy power bi