Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
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)
Image 2
Measure
Image 1
Image 2
Regards,
Ansar.
Solved! Go to Solution.
Hi @ansar
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.
Best Regards,
Community Support Team _ Yingjie Li
@ansar
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 )
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@ansar
If you can share a dummy file with your scenario and show the issue then I can check on that.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
114 | |
94 | |
87 | |
75 | |
65 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |