PowerBI's Table Visual as live data source and Sales Bin Measures

[Anonymous]

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? 😞

[Anonymous]

Hi @Anonymous 

Can you provide some sample data and the output you want so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

[Anonymous]

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

[Anonymous]

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.