Willstein818
New Member
Hello All,
I'm currently new to Power BI and DAX Measures. This tool helps a lot in bringing my dashboards to next level and ease up my workloads. However, there is one slight issue, here is my data set and measures that I've created in order to find out store target and achievements based on each respective sales baselines per Item Products (SKU) (Attached).
The programs ran smoothly, however, sometimes the users wants to know combined targets and achievements for each stores, and when they tried to select multiple SKU Options, it shows this:
This is my DAX Formula for Monthly Target Calculation:
I feel like there is an additional filter needed in order to solve this error but I don't know how. Could please anyone have an idea how to solve this?
Thank youu and Much Appreciated.
Regards,
Willstein
I'm currently new to Power BI and DAX Measures. This tool helps a lot in bringing my dashboards to next level and ease up my workloads. However, there is one slight issue, here is my data set and measures that I've created in order to find out store target and achievements based on each respective sales baselines per Item Products (SKU) (Attached).
The programs ran smoothly, however, sometimes the users wants to know combined targets and achievements for each stores, and when they tried to select multiple SKU Options, it shows this:
This is my DAX Formula for Monthly Target Calculation:
I feel like there is an additional filter needed in order to solve this error but I don't know how. Could please anyone have an idea how to solve this?
Thank youu and Much Appreciated.
Regards,
Willstein