Can any one help here what is the correct DAX formula ,
I have a measure to find out unique numbers of customers who is contributing 80% of the provision value (Measure [Prov USD])
Image 1 showing total provision by customer (all customers ,filtered as per slicer) also another table where i have shown with manual filter applied to visual to understand how many customers contributing 80% (If we take cumulative total of 8 customers provision [Prov USD] it is comming upto 80% of the total provision amount)
My measure Customers Contribute 80% showing correct values 8 in the card in image 1,
Where as in image 2 i have done an additional filter (Slicer selected year 2021 data table) compared to image 1,
the distinct customer count is showing 8 instead of 7 ( if you check the 2nd table it is showing only 7 customers)
Solved! Go to Solution.
Can you share a [Cumulative %] measure code here?
Is that year slicer connected to "Customer DB" or "Data" tables? Can you share samples of your tables here?
Appreciate your Kudos✌️!!
@VahidDM : Thanks for your reply
My fact table is connected to date table also with customer DB table,
Customer DB dont have direct relation ship with date table.
Hi @ansar ,
What is the [Prov USD] measure look like? Notice multiple measures quoted this measure
In addition, you can consdier sharing a dummy sample file which just includes the Customer table, Data table and the Date table with the necessary columns in this issue.
Community Support Team _ Yingjie Li
Can you try the following measure? You can add the Customer Key or Code .
Customers Contribute 80% = COUNTROWS ( FILTER ( VALUES ( 'Customer DB'[Customer ID] ), [Cumulative %] <= 0.8 ) )
Get a sneak peek into this year's Power Platform Conference Keynote.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!