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.
So i have this calulated table:
calculated_sum_total = SUMMARIZE( 'pick data'; 'pick data'[date]; 'pick data'[hour]; "linietotal";sum('pick data'[linie]) )
I want it to interact with two other columns from 'pick data' table. Tried the if(isfiltered combinations but only got error as resluts.
Bet it's simple, but I'm new with DAX, so please help.
ok Nevermind. I was simple as that:
calculated_sum_total = SUMMARIZE( 'pick data'; 'pick data'[date]; 'pick data'[hour]; 'pick data'[column1]; 'pick data'[column2]; "linietotal";sum('pick data'[linie]) )
Then jus put the slicer on theese two columns.
But now i have some other problem. I want the average of sum, by hour. Adding Column 1 and 2 has changed (lowered) the result i want. I could stay with my first example with values summed by hour only, but need the 2 slicers.
So i need the formula to sum the values by hour, and then take the average from the calculations, from the date range, set from another slicer.
@blazko wrote:
ok Nevermind. I was simple as that:
calculated_sum_total = SUMMARIZE( 'pick data'; 'pick data'[date]; 'pick data'[hour]; 'pick data'[column1]; 'pick data'[column2]; "linietotal";sum('pick data'[linie]) )Then jus put the slicer on theese two columns.
But now i have some other problem. I want the average of sum, by hour. Adding Column 1 and 2 has changed (lowered) the result i want. I could stay with my first example with values summed by hour only, but need the 2 slicers.
So i need the formula to sum the values by hour, and then take the average from the calculations, from the date range, set from another slicer.
Not quite clear about your scenario, it seems that you can create a calculated column on that summized table.
average column = CALCULATE ( AVERAGE ( 'calculated_sum_total'[linietotal] ), ALLEXCEPT ( 'calculated_sum_total ', 'calculated_sum_total'[date], 'calculated_sum_total'[hour] ) )
By the way, you may not have to create the summized table and columns, could you post the whole picture of your case? I think you may achieve your goal by using some visuals like table or matrix along with measures.
So i have this big base table 'pickdata', to simplify, with columns: date, sector, order number, order type, order product qty, and hour of realisation.
the problem is with the smaller chart on the left. It calculates (should be) the AVERAGE order qty realisation by hour.
Al this should interact with 2 slicers: order type, and sector.
So it should sum products qty of all orders from from all hours, from selected date range, and then calculate average from them.
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |