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 September 15. Request your voucher.
The following measure is being used as the denominator in a calculation but I have a slicer on the page where if I select a value from the slicer I don't want the denominator value to change. In the table below I always want the denominator to be 6381 regardless if I select either Same Month or Diff Month from the slicer on the page. This has to be able to work in a table that has more than one month at a time...e.g. it will have each month of 2022 and each month will have different expirations.
CalendarYear | Expirations |
2022 | 6381 |
Feb | 6381 |
Same Month | 6199 |
Diff Month | 182 |
Solved! Go to Solution.
Figured it out;
CALCULATE(sum(Combined[Units]),USERELATIONSHIP('Date'[Date],Combined[ExpirationDate]),ALL(Combined[MONTH BIN]))
Figured it out;
CALCULATE(sum(Combined[Units]),USERELATIONSHIP('Date'[Date],Combined[ExpirationDate]),ALL(Combined[MONTH BIN]))
User | Count |
---|---|
69 | |
64 | |
62 | |
54 | |
28 |
User | Count |
---|---|
112 | |
81 | |
65 | |
48 | |
42 |