Forum Discussion
Create column filled with measures
I want to create a bar chart wich gives the targeted value against the counted value of visit reports.
The Bleu bars are the target. The others are all values from a created measure, which counts the number of visit reports from an other table filtered by acq/contr verl/klantonderh/ROS.
Count acq bez = CALCULATE(COUNT('Bezoek rapport'[Outlet]);FILTER('Bezoek rapport';'Bezoek rapport'[Reason Visit]="Acq"))
Now I would like to have only the right measure compared to the right target.
So "Doel bezoeken "acq"" against "count acq bezoeken"
I thought of an IF( formula that places the measer behind the column if the name is acq/contr verl/...
Can anyone tell me how to do this?
Or is there a better way to achive my wanted visual?
Thank you for your help!
It took me some time but I got it to work with the drill down.
But I had to create a seperate table in order to make a relationship between the 2 other tables.
Thank you very much for your help!
6 Replies
Anonymous,
Your requirement is not very clear. Show us a complete example, please.
Sorry, I will try to clarify
I have the following table:
Sales representative | Visited company | type |
Representative A Company A acq
Representative A Company B acq
Representative A Company C contr verl
Representative A Company A ROS
Representative B Company D Klant onderh
Representative B Company E ROS
Representative B Company F ROS
Representative B Company G acq
Representative C Company H Contr Verl
Representative C Company I ROS
etc
A second table:
Sales representative | type | Goal # visits |
Representative A acq 150
Representative A ROS 120
Representative A contr verl 30
Representative A Klant onderh 80
Representative B acq 200
Representative B ROS 150
Representative B contr verl 50
Representative B Klant onderh 100
Representative C acq 80
Representative C ROS 120
Representative C contr verl 130
Representative C Klant onderh 180
The report pages are always shown with a filter on sales representative.
Right now I have created KPI visuals which count the number of visit companies with a filter on ""type".
And at target the "Goal # visits"
However, I still find this unclear because I get a lot of different visuals with number while it is not that important information on the report.
To make it more clear I would like to create a bar chart that shows The actual count of visits against the targeted. Seperated (legend) by type.
I hope this makes it more clear