Forum Discussion
PowerBI's Table Visual as live data source and Sales Bin Measures
I want PowerBI's Table Visual to act as a live table. This way I can use measure values as column values and filter the data in the dashboard. Right now, I cannot use visuals as filters or use them on cards because of dependencies. E.g., I have created measures to calculate the Incentives of the Salespersons but I am unable to do simple calculations like the count of salespersons who have received the incentive. I have tried creating columns but they are static. I want the values to be dynamic and updated on a real-time basis which is why I used measures.
Similar is the case with creating bins. Whenever I create Sales bins via measure, I cannot use them as filters. I want to filter the data based on the bins I created. Please help, how can I solve it? 😞
3 Replies
Hi Yolo, Thank you for replying.
Following is what I want to achieve in the Dashboard. There are two problems:1) I am unable to create Cards for "Total Salespersons who received Incentive in Region 1" etc. or Count of Salespersons who received Incentive. Because Incentive is a Calculated Measure.
2) I have created bins using a measure for Target vs Achievement of Sales but I am unable to use this as a Slicer. The data doesn't show me the number of Salespersons who achieved in the bin (100%-109.99%) sales.
Now, I do not want to create a column because columns are static and not dynamic.
Ps: The data has Regions (Column), Year (Column), Salesperson's ID, Salesperson's Name, Targets (Column), Sales(Column), Achievement% (Measure), Achievement Bin (Measure), Total Incentive(Measure).
Sample Data:
RegionsYearSalesperson IDSalesperson NameTargetSales
Region 1 2023 1 Salesperson 1 100 116 Region 1 2023 2 Salesperson 2 100 106 Region 1 2023 3 Salesperson 3 100 102 Region 1 2023 4 Salesperson 4 100 98 Region 1 2023 5 Salesperson 5 100 88 Region 1 2023 6 Salesperson 6 100 81 Region 1 2023 7 Salesperson 7 100 78 Region 1 2023 8 Salesperson 8 100 60 Region 2 2023 9 Salesperson 9 100 112 Region 2 2023 10 Salesperson 10 100 95 Region 2 2023 11 Salesperson 11 100 80 Region 2 2023 12 Salesperson 12 100 78 Region 2 2023 13 Salesperson 13 100 70 Region 2 2023 14 Salesperson 14 100 60 Region 2 2023 15 Salesperson 15 100 50 Hi Anonymous
For the first problem, you can use the filter() function to calculate the quantity.
e.g
Measure = CALCULATE ( COUNTROWS ( table ), FILTER ( table, [Regions] = "Region1" && [Incentive] > 500 ) )For the second querstion, the measure cannot be put into a slicer, it is a virtual data, the slicer need to put a existed column, so it's better to creata a column.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.