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.
Need help on the below data. i want the ClothsWeight and HomeWeight to be appearing for all the rows. Without having any filters on it. I tried allexcept , All But it is not working. Below is the code i have now
Quarter | Type | WeightedValue | index | filter | Groups |
Q2 2019 | Cloths | 0.41 | 1 | Person | T2T |
Q2 2019 | cloths | 0.41 | 2 | Person | T2T |
Q2 2019 | cloths | 0.41 | 3 | Person | T2T |
Q2 2019 | Home | 0.05 | 4 | Person | B2B |
Q2 2019 | Home | 0.05 | 5 | Owner | B2B |
Q2 2019 | Home | 0.05 | 6 | owner | B2B |
Q2 2019 | Home | 0.05 | 7 | Person | B2B |
Q2 2019 | Vehicle | 0.54 | 8 | Person | B2B |
Q2 2019 | Vehicle | 0.54 | 9 | owner | T2T |
Q3 2020 | cloths | 0.45 | 10 | owner | T2T |
Q3 2020 | cloths | 0.45 | 11 | owner | B2B |
Q3 2020 | Home | 0.05 | 12 | Person | B2B |
Q3 2020 | Home | 0.05 | 13 | Person | B2B |
Q3 2020 | Home | 0.05 | 14 | owner | B2B |
Q3 2020 | Home | 0.05 | 15 | owner | B2B |
Q3 2020 | Vehicle | 0.5 | 16 | Person | T2T |
please try this
Measure = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALL('table'),'table'[Type]="Home"))
Measure2 = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALL('table'),'table'[Type]="cloths"))
Proud to be a Super User!
With that measure i am getting the overall Average value. But i want the below output
For Q2 2019 Cloths i want .41 in all rows for clothsWeight
For Q2 2019 Home i want .05 in all rows for HomeWeight
For Q3 2020 Cloths i want .45 in all rows for clothsWeight
For Q3 2020 Home i want .05 in all rows for HomeWeight
pls try this
Measure2 = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALLEXCEPT('table','table'[Quarter]),'table'[Type]="cloths"))
Proud to be a Super User!
The Solution is working for measures for same table. I have an additional measures for which i use date table and get Quarter from it for previous Quarter calculation. In the Relationship i join on the Column DateCustom with Values 4/1/2019 and 7/1/2019. for Q2 2019 AND Q3 2019.
In the Visual i use YearQuarter from Dim Date
Dim Date = CALENDAR(date(2019,1,1),date(2021,12,31))
I didn't create full calendar just quarter
Measure = CALCULATE(AVERAGE('table'[WeightedValue]),FILTER(ALLEXCEPT('table','table'[Quarter],DIMTIME[Quarter]),'table'[Type]="cloths"))
please try if this works for u.
Proud to be a Super User!
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |