Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |