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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
---|---|
97 | |
78 | |
77 | |
49 | |
26 |