The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am trying to find the right way to create a measure that is not affected by the filter slicers that are on the PBi page, but that is filtered by the year of the data.
The measure I want to creat is the sum of a whole column, filtered by all the values that are from 2021 and for now i have the following:
Hi There,
I have tried something similar though I am wanting to find the average of everything without the filter effecting the number but having some issues. Below is the code
I ended up doing something very similar to this, but for some reason my date column did not want to filter by year, so i simply made a column "Year" in my table. Thank you!
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
30 | |
14 | |
12 | |
12 | |
7 |