Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a measure that calculates the average KPI using YTD data (the number will be updated along with the dataset update monthly). I need the calculated number to remain unchanged for all months rather than being calculated for each month. Dax that I'm using (Orange line):
(The number changes every month)
When I add && 'KCX database'[Month] >= "1" && 'KCX database'[Month] <= "12" in FILTER, it shows the correct number but for Jan only.
How do I make it only calculate the overall number instead of each month and show the same number for all months?
Thank you all!!!
Solved! Go to Solution.
I figured it out!!!
For those who need it, follow as below because it worked with me.
Step 1: Create a new dataset using "Enter Data" function. You will then add a month column from 1-12.
Step 2: Go to Model View, and create a relationship with the month column using your new dataset and your original dataset.
Step 3: Add a new column to your new dataset using "New Column" function. You will then write (or copy) your measure into this column.
Step 4: Drag your measure to the chart, change the type to MAX (it is usually set as count) and woala!!!
From my understanding, when you do it this way, the system will understand that your measure is run individually for each month instead of run by YTD for every month.
Hope it works for you too!!!
I figured it out!!!
For those who need it, follow as below because it worked with me.
Step 1: Create a new dataset using "Enter Data" function. You will then add a month column from 1-12.
Step 2: Go to Model View, and create a relationship with the month column using your new dataset and your original dataset.
Step 3: Add a new column to your new dataset using "New Column" function. You will then write (or copy) your measure into this column.
Step 4: Drag your measure to the chart, change the type to MAX (it is usually set as count) and woala!!!
From my understanding, when you do it this way, the system will understand that your measure is run individually for each month instead of run by YTD for every month.
Hope it works for you too!!!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
211 | |
86 | |
64 | |
59 | |
56 |