Hi. thanks for your attention
Here are the polished sentences:
"The dashboard consists of two pages. One page shows the status, and the other is solely for tool tips.
On the main page, there are measured values listed as follows:
- Order Quantity - written using a slicer
- Maximum Distance - the minimum required condition. If I choose 30 km, the map shows factories within a 30 km radius.
- Possible factory and distribution quantity - if I input an order quantity of 30 ea and a maximum distance of 10km, it shows possible factories. For instance, the possible quantity of a factory is only 5, meaning that each factory should make 6 ea for the order. The distribution quantity is calculated by dividing the order quantity by the possible factory count.
below Dax is what i used for count
Possible_Factory = COUNTROWS(FILTER('table', [Calculate_distance] <= 'Max_distance'[Max_distance_Value]))
Distribution_Quantity y= Order_Quantity / Possible_Factory
The other page is for tool tips. It shows the following information:
- Factory Capability - each factory is different and has varying capabilities. Some can make 3 ea per day, and others can make 10 ea per day. Therefore, I want to compare the distribution quantity to the factory capability.
The problem occurs in the tool tip. The distribution quantity is not shown. i found right number of Order Quantity but Possible_Factory is not calculated in the tooltip page. i think count function is not work. because all of filter is input in the main page. i think its filtered information is not shared to tool tip page.
Is there another way to create a graph that compares the current distribution quantity to the factory capability in the tool tip?"
it is very helpfull to make measure value that compare selected condition is maintain in the tool tip.
thanks for your concern.
