Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need help with Line & Clustered Column Chart

Hi Everyone, I'm relatively new to the BI platform and was hoping to get some help with a project I am working on. I can't disclose a lot of detail but will try to provide enough information to hope...
Need Help
Tips and Tricks
Tutorial Requests
  • samdthompson's avatar
    samdthompson
    4 years ago

    Hello, I have some similar stuff I have to do around pricing. To tackle it i use two measures:

     

    CustomerPrice = SUM(DataTable,DataTable[Price])

    ComparisonPrice = CALCULATE([CustomerPrice], ALL(DataTable]))

     

    I can then show the customers on the bars and the comparison as a line. You may want to be more nuanced about the comparison line ie you do want to vary regionally or some such. In that case it might be something like:

     

    ComparisonPrice =

    CALCULATE([CustomerPrice],FILTER(ALL(Customer),Customer[Region]=SELECTEDVALUE(Customer[Region]))).
     
    Hope this points you in the right direction anyway.
     
     
samdthompson's avatar
samdthompson
Memorable Member
4 years ago

It will depend on which table your measure sits and which table the filter is on and the relationship direction. If you have a customer table which you are using a a filter, make sure that the relationship is 1:* not bi directional. also make sure that the axis holding the customer name comes from the customer table. In the measure make sure that the filtering refers to the customer table noth the fact table. These are just some things to check but its a bit stab in the darkish without seeing the table layout.