Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 | |
B2 | MICROSOFT |
B3 | AMAZON |
POWERBI MATRIX
ACCOUNT_TYPE_A | ACCOUNT_TYPE_B | REVENUE | ACCOUNT_TYPE_A_THRESHOLD |
APPLE | 21 | 100 | |
11 | |||
MICROSOFT | |||
AMAZON | |||
HP | 14 | 90 | |
MICROSOFT | 14 | ||
AMAZON | |||
DELL | 80 | ||
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
19 | |
16 | |
16 | |
16 |
User | Count |
---|---|
51 | |
23 | |
20 | |
17 | |
16 |