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.
Hello,
I have this data and I visualized it using a matrix table.
Transaction | Invoice | Status |
NO-11297 | NO-11297-1 | Void |
NO-11297 | NO-11297-2 | Invoice Paid |
NO-11297 | NO-11297-3 | Invoice Sent |
NO-11301 | NO-11301-1 | Invoice Paid |
NO-11301 | NO-11301-2 | Invoice Paid |
NO-11303 | NO-11303-1 | Invoice Paid |
NO-11303 | NO-11303-2 | Invoice Paid |
NO-11305 | NO-11305-1 | Invoice Paid |
NO-11305 | NO-11305-2 | Invoice Paid |
NO-11308 | NO-11308-1 | Invoice Paid |
NO-11308 | NO-11308-2 | Invoice Sent |
NO-11309 | NO-11309-1 | Invoice Paid |
NO-11309 | NO-11309-2 | Invoice Sent |
I am trying to filter the table to show parent transactions + all their child rows if subtotal of COLUMN > 0
Column = IF(data2[Status] = "Invoice Paid", 0, 1)
--> hide all in yellow highlight
When trying to use the COLUMN as filter, it only filters those with Invoice Sent or Void values. I need to see all children of these parent transactions
Thank you in advance!
Solved! Go to Solution.
Hi,
Use a measure instead:
MyMeasure1 =
CALCULATE(
COUNTROWS( data2 ),
data2[Status] <> "Invoice Paid",
ALLEXCEPT(
data2,
data2[Transaction]
)
)
Drag it into the filters pane and set it to greater than 0.
Regards
You're welcome!
Cheers
Hi,
Use a measure instead:
MyMeasure1 =
CALCULATE(
COUNTROWS( data2 ),
data2[Status] <> "Invoice Paid",
ALLEXCEPT(
data2,
data2[Transaction]
)
)
Drag it into the filters pane and set it to greater than 0.
Regards
Excellent! Thank you so much, i really appreciate it!
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 |
---|---|
47 | |
23 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
42 | |
39 | |
19 | |
19 |