Forum Discussion
How to create a descriptive satistics table?
Hi Anonymous ,
Based on the sample data you provided, I created a test pbix file
Select the two columns and click unpivot other column.
Then create the measure according to your requirements and drag them into the matrix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous ,
Based on the sample data you provided, I created a test pbix file
Select the two columns and click unpivot other column.
Then create the measure according to your requirements and drag them into the matrix.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey V-lianl-msft ,
Thanks a lot for the explanation and the demo file.
At first I did what you suggested, and it worked for creating the summary table, but broke the visualizations I already had in the report, because the fields they used were no longer present. So what I did to fix this was duplicate the original query in Power Query, then do the unpivot other columns step and then create the necessary relationships, namely a one-to-many relationship between publicacao[id] and the new table[publication_id], and a many-to-many inactive relationship between the pivoted table[distribution_date] and the unpivoted_table[distribution_date], as shown below:
Finally, to create the min, max and average metrics, I used a combination of CALCULATE, the respective metric and USERELATIONSHIP function. It was necessary to use the many-to-many relationship so that the values in the table visualization got updated according to the distribution date slicer I use in the report:
I confirmed the values in the matrix were correct by comparing them to the measures I had previously created for each attribute (entrega, forecast, venda).
Best regards,
Ricardo