Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello experts,
I don't have too much time working with Power BI and i have a question regarding summarising table (maybe my problem is more simple than I think).
I have a table with multiples colums, each one with multiples values in a period of time. I want to create a one single table (visual chart) with the resume of the min, max, variance, average and deviation of each colum.
This is what i did:
1. I created a calculated colum for min, max and average of each colum in my main table
2. I created a summarized table to put all the calculated values in a single chart, using a UNION
Totaux = UNION( SUMMARIZE ( 'STATIS'; "Valeurs"; "MAX"; "CPU Max"; 'STATIS'[Max CPU MAX]; "Reboot";'STATIS'[Max Reboot]; "GPS OK";'STATIS'[Max GPS OK]; "GPS KO";'STATIS'[Max GPS KO] ); SUMMARIZE ( 'STATIS'; "Valeurs"; "MIN"; "CPU Max"; 'STATIS'[Min CPU MAX]; "Reboot";'STATIS'[Min Reboot]; "GPS OK";'STATIS'[Min GPS OK]; "GPS KO";'STATIS'[Min GPS KO] ) )
My problem: Power BI doesn't allow me to "JOIN" more than Two rows, and I still need to create rows for variance, average and standard deviation.
Any ideas?... thanks in advance for your help
Hi @rostromarre,
I think you needn't to create a a summarized table here. You can create measures to work on it. Could you please share your sample data and excepted result to me.
Regards,
Frank
Actually i created measures for each value, mu problem is to put everything in one single chart...
I still looking for a solution. I really appreciate if someone can give me some advises.
thanks in advance.
Hello @v-frfei-msft
Thanks for your reply!
This is my sample date:
After selected a period of time (using a filter on the champ date), the repport must show the table below:
Thanks in advance for your help
User | Count |
---|---|
92 | |
86 | |
67 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |