Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
111 | |
104 | |
85 | |
65 | |
63 |