I have a table in Power BI called Registration. The table has the following columns: timestamp, weekDay, Hour, events_failed. timestamp is the timestamp column, weekDay is the name of the day in the week like "Sunday", "Monday", "Tuesday", etc. Hour has the hour of the events and Hour goes from 0 to 23. 'events_failed' column is of data type integer and hold the number of events that has failed at that Hour. However, I can have many rows in a single Hour as there are other But here is the tricky part: I want to calculate percentile 25 of every group combination of weekDay and Hour. Example: percentile 25 for all 'Tuesday' at Hour 16, and following along the same way for all combinations of weekDay & Hour. In summary, I want to write a Measure in DAX that calculate the percentile 25 of 'events_failed' for all different combinations of groups of weekDay and Hour. I want the results in a new table called Percentiles with the following columns: weekDay, Hour, Percentiles_25, Percentiles_75.
