Min on entire dataset

[miap]

Hello,
I have a dataset I have been using for a while, and now I need to add a new fact table that will multiply all the rows in the original dataset and change the whole measures I am using in the dashboard.
The original data set is complicated and has a lot of measures.

What is the best way to deal with this situation?

Thanks,
Mia

[David_Wong]

Hi @miap,

Can you try this?

minOver({field_name}, [], PRE_AGG)

[Karthik_Tharmarajan]

Hi @miap, As @David_Wong pointed out you will need to use Level Aware Calculations to ensure the aggregations are happening at the right level. Please refer to the link that @David_Wong published a while ago or you can also refer to QuickSight documentation for Level Aware Calculations.

Level-Aware Calculations: Tips and Best Practices

[Level-Aware Calculations in Amazon QuickSight] Level-Aware Calculations (LAC) are powerful functions that allow us to perform calculations at a granularity level which is different from the granularity of our datasets and/or visuals. The sample dataset referenced by this article is a dataset of product orders placed by customers. Each order can contain multiple products and each product in an order has a unique Line Item ID. Each row of our dataset represents one line item but we want to per…

Regards,
Karthik