Forum Discussion
Measure Interaction not working
Hi,
I'd like ot help but the data you have shared in the other thread is no clear. Please share the input tables, describe the business question and show the expected result.
- Anonymous6 years agoNot applicable
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 - Ashish_Mathur6 years agoSuper User
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