Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an aging table.
My data is like this:
Customer | Aging | Amounts |
Apple | Not Due Yet | 4.000.000 |
Apple | 1-30 days | 1.500.000 |
Apple | 31-60 days | 300.000 |
Apple | 61-90 days | 200.000 |
Microsoft | Not Due Yet | 50.000 |
Microsoft | 1-30 days | 500.000 |
Microsoft | 31-60 days | 200.000 |
Microsoft | 61-90 days | 100.000 |
1-30 days | 600.000 | |
31-60 days | 700.000 | |
61-90 days | 400.000 |
I have a measure to calculate the
Overdue = CALCULATE(SUM('CustomerAging'[Amounts]),'CustomerAging'[Aging]<>"Not Due Yet")
I want to create slicers/buttons so the user can choose to show aging of customer with certain conditions:
Overdue > 2.000.000
Overdue > 1.000.000
Overdue > 500.000
If i use the filter in the report and filter the visual by Overdue is greater than 1 000 000 it works perfectly.
I created a measure like this:
Customer | Aging | Amounts |
Apple | 1-30 days | 1.500.000 |
Hi @MegaOctane1 ,
not sure if i fully get you, try like:
1) create a calculated table like below and plot a slicer accordingly:
Slicer =
SELECTCOLUMNS(
{500000, 1000000, 2000000},
"Overdue", [Value]
)
2) plot a card visual with a measure like:
OverdueOverSelection =
VAR _table =
ADDCOLUMNS(
VALUES(CustomerAging[Aging]),
"Amt",
CALCULATE(SUM(CustomerAging[Amounts]))
)
VAR _result =
SUMX(
FILTER(
_table,
[Amt] > SELECTEDVALUE(slicer[overdue])
&& CustomerAging[Aging]<>"Not Due Yet"
),
[Amt]
)
RETURN _result
it worked like:
Sorry, I have corrected the Overdue measure.
The correct DAX formula:
Overdue = CALCULATE(SUM('CustomerAging'[Amounts]),FILTER(CustomerAging,CustomerAging[Aging] <> "Not Due Yet"))
I have created three matrix tables to show what i want to get out of this "slicer filter".
How can i get the result without filtering the visual in the filter pane?
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
30 | |
13 | |
11 | |
9 | |
6 |