Forum Discussion
Helper ITable Visual not showing any result
I have this dataset:
| Group1 | Group2 | Group3 | Type |
| A | A1 | A11 | T1 |
| A | A1 | A11 | T2 |
| A | A1 | A11 | T3 |
| A | A1 | A11 | T4 |
| A | A1 | A12 | T1 |
| A | A1 | A12 | T2 |
| A | A1 | A12 | T3 |
| B | B1 | B11 | T1 |
| B | B2 | B21 | T1 |
| B | B2 | B21 | T2 |
| B | B2 | B21 | T3 |
I summarized the number of types per Group3 items:
| Group1 | Group2 | Group3 | Count |
| A | A1 | A11 | 4 |
| A | A1 | A12 | 3 |
| B | B1 | B11 | 1 |
| B | B2 | B21 | 3 |
I created two measures. One is [Type Count] = distinctcount([Type]). The other is [Group3 Count] = calculate(distinctcount([Group3]), [Type Count] >= 3).
If I create a matrix visual (with filter [Item Count] is greater or equal to 3), the result looks like this:
| Group1/Group2 | Item Count |
| - A | 7 |
| - A1 | 7 |
| A11 | 4 |
| A12 | 3 |
| - B | 3 |
| - B2 | 3 |
| B21 | 3 |
This is correct.
I need to create table visuals to show [Group3 Count].
If I create a table visual for Group1, the result should look like this:
| Group1 | Group3 Count |
| A | 2 |
| B | 1 |
If I create a table visual for Group2 with a slicer for Group1, it should look like this:
Group1 slicer = A
| Group2 | Group3 Count |
| A1 | 2 |
| B2 | 1 |
But for both tables, I'm getting no results. I need some advice on how to accomplish this. Thank you.
jabrillo ,
Create a measure
[Type Count] = Count(Table [Type])
Then create a measure
calculate(Countx(filter( Values(Table[Group3]), [Type Count] >= 3) , [Group 3]) )
This should work with first tables group 1, 2 etc
3 Replies
- amitchandak
Super User
jabrillo ,
Create a measure
[Type Count] = Count(Table [Type])
Then create a measure
calculate(Countx(filter( Values(Table[Group3]), [Type Count] >= 3) , [Group 3]) )
This should work with first tables group 1, 2 etc
jabrilloThank you amitchandak. This works.
v-jianboli-msftCommunity Support
Hi jabrillo ,
Please try:
Measure = var _a = SUMMARIZE('Table','Table'[Group1],'Table'[Group2],'Table'[Group3],"Count",COUNT('Table'[Type])) return COUNTX(FILTER(_a,[Count]>=3),[Count])Output:
You mentioned that the second visual uses a slicer with Group1=A. If so, B2 does not appear in the visual, do I misunderstand?
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.