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.
Hi friends.
I have the following table (blue columns):
And I need to add 2 new columns (orange ones):
1) DIVIDER: wich is the sum of WEIGHT grouped by PROJECT, and it must be affected by PLAN DATE used as visual filter
2) VALUE: it is WEIGHT divided by DIVIDER (WEIGHT/DIVIDER)
What I mean with PLAN DATE used as visual filter:
Per example if I choose year 2020 in the visual filter, the table must be show like this:
Or If I select year 2019 in the visual filter:
Thanks in advance, I'm looking foward for your help.
Solved! Go to Solution.
I see, it'll only work if you change the Plan Date on the table to Date Hierarchy so try this one and lets see if it works:
I'll advise to make a Date table then you can also select the fields you want to use as filter there
Hi,
You may download my PBI file from here.
Hope this helps.
No need to have a separate column for divider.
Thanks a lot Dustinn!
It work perfectly in case that the filter is just year, but I need to set up the visual filter as "between" (period of time and not just years) and in that case it doesn't work.
Do you know how to solve it?
@MauroBote Use 'Table'[Plan Date] since you are using the Plan Date filter itself.
Like this:
Measure = DIVIDE(SUM('Table'[WEIGHT]);CALCULATE(SUM('Table'[WEIGHT]);ALLEXCEPT('Table';'Table'[PROJECT];'Table'[PLAN DATE]));0)
It doesn't work either, because for the example the measure of tasks at4 and at5 should be 60% and 40% respectively.
I see, it'll only work if you change the Plan Date on the table to Date Hierarchy so try this one and lets see if it works:
I'll advise to make a Date table then you can also select the fields you want to use as filter there
Perfect!!! You are a genius!!!
Thankssss!!!
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 |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |