Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Overview:
I have a date based table in which I have the following columns:
ID, Date (from today's date to historical date) (ex. March 21 2023, March 20 2023, March 19 2023 etc), Plan Type and Amount.
I am using the following formula:
I need help fixing my measure to get the required result. Thank you in advance.
Try replacing the [Date Key] with whatever ID column you're using in the date table, or the field used in the relationship between the two tables.
Potential issue with the 'Measure 6' formula is related to the filter context of the 'Plan Type' column. When you use the ALL function on the 'Plan Type' column, it removes the filter context of that column, which is causing the same value to appear in every row of the 'Measure 6' column.
To fix this issue, you can use the VALUES function to get a table of distinct values in the 'Plan Type' column and iterate over them using the SUMX function. Here is an updated formula that should work:
Measure 6 =
SUMX (
VALUES ( 'Worker Compensation Detail All'[PLAN TYPE] ),
CALCULATE (
SUM ( 'Worker Compensation Detail All'[PAY RATE_] ),
FILTER (
ALL ( 'Worker Compensation Detail All'[PLAN TYPE] ),
'Worker Compensation Detail All'[Date Key] = MAX ( 'Worker Compensation Detail All'[Date Key] )
)
)
)
I hope I am understanding your issue correctly and hope this helps
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
38 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |