Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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.
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.
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.
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.
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |