Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
74 | |
54 | |
50 | |
44 |