Forum Discussion
Problem including variables in graphs
My data is about the financial statements of some companies, linked by its RIC which is a specefic code for each company and by the date. The thing is that For some variables such as total assets, I calculated the percentils and when I want to compare the percentil 75 for example of total assets of the whole data set with just the total assets of one company, power bi uses the percentile 75 just of that one and not of the entire data because the variables are linked as I previously said. Id like to know if there is a way to make the percentil (the new measure) independent of the company code when doing a chart because if not, I wont be able to compare a single company with the average/percentile.... of the whole data set.
In the image, the percentil 75 is calculated based in the filter I have to put in the RIC (only use company A)
thanks in advance
Hi Luiscede12 ,
You want get the whole data when do some filters? You can just add ALL('Table'[Company]) or REMOVERFILTERS('Table'[Company]) like the following expression.
all data = CALCULATE(SUM('Table'[Values]),ALL('Table'[Company]))Pbix file in the attachment you can refer. If I misunderstood you, please let me know and share your data with table or something could be copied and expect result.Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Luiscede12 ,
You want get the whole data when do some filters? You can just add ALL('Table'[Company]) or REMOVERFILTERS('Table'[Company]) like the following expression.
all data = CALCULATE(SUM('Table'[Values]),ALL('Table'[Company]))Pbix file in the attachment you can refer. If I misunderstood you, please let me know and share your data with table or something could be copied and expect result.Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.