Forum Discussion
sum each Distinct counts base on slicer
Hello,
I have a measure that calculates the distinct count of customers
In my report, there is also a Segment filter ( Segment X,Y,Z) , and customers can belong to multiple Segments.
The segment is from a segment table, consists of a customer ID column and a Segment column, customer ID column have duplicates. if
I want to return double-counted results: for example:
when one segment is selected, then return distinct count of that segment,
but when multiple segments are selected, I want to return the sum of the distinct count of customers in the selected segments
I figured out, this can be done using Sumx founction
3 Replies
- parry2kSuper User
dgdgdg122db can you paste sample data and the expected output Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 - dgdgdg122dbHelper II
I figured out, this can be done using Sumx founction
- quangbilly79Regular Visitor
How?? Please post your answer? Don't just say I figured it out and quit?