Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |