Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Thank you ahead of time. Below is a simplified table where I want to count how many EN users selected Chat.
I was trying to figure out how to group the information of the User and count if both EN and Chat were in the grouping but I don't have the knowledge how to do it.
User | Operation | Description | Selection |
User1 | Menu | Language | EN |
User1 | Menu | Sales | Parts |
User1 | Xfer | SMS | Chat |
User2 | Menu | Language | ES |
User2 | Menu | Sales | New |
User2 | Xfer | Live | Agent |
User3 | Menu | Language | EN |
User3 | Menu | Service | Returns |
User3 | Xfer | Live | Chat |
@TodS9, here is my suggested solution.
Create a measure called [Has EN and Chat] with this DAX formula:
Has EN and Chat =
SUMX(
VALUES(YourTable[User]),
VAR hasEN = CALCULATE(DISTINCTCOUNT(YourTable[User]), YourTable[Selection] = "EN")
VAR hasChat = CALCULATE(DISTINCTCOUNT(YourTable[User]),YourTable[Selection] = "Chat")
RETURN IF(hasEN > 0 && hasChat > 0, 1)
)
Add a table visual to your report and drag the [User] column and the [Has EN and Chat] mesaure. This gives the output below:
Is this what you are looking for?
Thanks @EylesIT , I was able to get the data needed. It would have been weeks if ever for me to figure this out. There's another column I want to show as the rows and not the "User" but I'll work on that. Awesome answer.
@TodS9 Try:
Measure =
VAR __Table1 = SELECTCOLUMNS( FILTER( 'Table', [Selection] = "EN" ), "User", [User])
VAR __Table2 = SELECTCOLUMNS( FILTER( 'Table', [Selection] = "Chat" ), "User", [User])
VAR __Result = COUNTROWS(INTERSECT( __Table1, __Table2 ) )
RETURN
__Result
Thanks @Greg_Deckler . This answer may allow me to get the information in the layout I eventually want. It's just going to take some extra time to learn and understand how it works. You guys are fantastic. I've been staring at this for a couple of weeks before breaking down and asking for help. Thank you!
User | Count |
---|---|
56 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |