Forum Discussion
Measure Interaction not working
Hello Ashish_Mathur
Below is the detail level
This might be a very simple issue but it turns out complex for me. Below is the table. I am trying to calculate tasks and orders which are balanced(which means sum Order Count = 0).
Count of distinct Orders = Calculate(distinctcount(order no))
Count of Orders in Balance =
Calculate(distinctcount(order no)),Filter(SUM(Order/Task Quantity = 0))
Count of Orders not in Balance =
Calculate(distinctcount(order no)),Filter(SUM(Order/Task Quantity <> 0))
Count of distinct Tasks = Calculate(distinctcount(task order no))
Count of Tasks in Balance =
Calculate(distinctcount(task order no)),Filter(SUM(Order/Task Quantity = 0))
Count of Tasks not in Balance =
Calculate(distinctcount(task order no)),Filter(SUM(Order/Task Quantity <> 0))
Expected Result (KPI's)
- Count of distinct Orders = 1
- Count of Orders in Balance = 0
- Count of Orders not in Balance = 1
- Count of distinct Tasks = 7
- Count of Tasks in Balance = 5
- Count of Tasks not in Balance = 2
I have Order No as a slicer, For example, if I select Order No 1350000-11 then it should display Count of Orders in Balance = 1 and Count of Orders not in Balance = 0. Same applies for the date range, If I select
Counts of Balanced Tasks is visualized in clustered bar chart and interactions should work as expected
Please help me with the above issue. Thanks!!
| Order No | Task Order No | Task Completed Date | Order/Task Quantity |
| 1350000 | 8/9/19 | 0 | |
| 1350000 | 1350000-11 | 7/31/19 | 0 |
| 1350000 | 1350000-12 | 8/1/19 | 0 |
| 1350000 | 1350000-13 | 8/9/19 | 0 |
| 1350000 | 1350000-14 | 8/9/19 | 0 |
| 1350000 | 1350000-15 | 8/9/19 | 0 |
| 1350000 | 1350000-8 | 8/1/19 | -370 |
| 1350000 | 1350000-8 | 8/1/19 | -90 |
| 1350000 | 1350000-9 | 7/31/19 | 0 |
| 1350000 | 1350000-9 | 7/31/19 | 4 |
| 1350000 | 1350000-9 | 7/31/19 | 95 |
Hi,
Share the link from where i can download your PBI file. Ensure your formulas are already wriiten there. Clearly show your problem there.
- Anonymous6 years agoNot applicable
- Ashish_Mathur6 years agoSuper User
Hi,
That link contains a zipped folder with no PBI file in that folder.