Measure not working in Values for charts

[Anonymous]

Hello,

I have a measure to calulate total customers in my store:

Customers = COUNTROWS(DISTINCT(SELECTCOLUMNS(FILTER(FACT,FACT[Appearance]=1 ),"x",Fact[ID])))

I have another measure from that to calulate the 25 Percentile of those customers through our the time period:

25p =

var A= ADDCOLUMNS(DimCalendar,"xCustomers ",[Customers ])

var B = PERCENTILEX.INC(t,[xCustomers ],0.25)

return CONCATENATE(SUBSTITUTE(FORMAT(i,"#,###"),",","."),UNICHAR(10))

Probelm is, i want to have the second measure (25p) on a line chart to see how the 25 Percentile changes overtime. The Customers measure works fine, but the 25p does not work on a line chart or a bar chart. I can do it in a table, but not on a chart.

Can anyone help or suggest me something?

Many thanks !

[amitchandak]

@Anonymous , refer if these can help

https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
https://finance-bi.com/power-bi-pareto-analysis/
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Calculate-the-sum-of-the-top-80/td-p/763156

[Greg_Deckler · Accepted solution]

@Jonas1992- You may need to use an ALL or ALLSELECTED with the percentile measure. Hard to say. It is not really enough information to go ahead, please first check if your problem is a common problem listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, check out this post on how to get answers to your question quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the edit bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. 2.

[Anonymous]

Yes ! It works with ALLSELECTED ! Thank you !!