Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi, I have a chart with 2 measure (Count Implemented, Count New Proposal) on X axis.
in my table I have two dates fields (proposal year and implemented year).
I whish Proposal year (Date 1) Affects New Proposal (measure 1) and
Implemented year affects (date 2) New Proposal (measure 2).
Those are the DAX script of measures:
Measure 1 (new proposal) = CALCULATE(SUM('Table 1'[Column 1]))
Measure 2 (Count Implemented) = CALCULATE(SUM('Table 1'[Column 1]),'TTable 1'[Status]= "Implemented"))
THanks
Solved! Go to Solution.
Hi @MonitorA,
You can add all functions to the expressions that you did not want to apply filter effects, then it will ignore the specific filter effects.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,
Xiaoxin Sheng
Hi @MonitorA,
You can add all functions to the expressions that you did not want to apply filter effects, then it will ignore the specific filter effects.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT - SQLBI
Regards,
Xiaoxin Sheng
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |