A list table with just one column

[koorosh]

Hello Experts, How can I get a list report of table "Top Partners" that shows just the name of partners (that have measure = 1 value).

https://1drv.ms/u/s!Apx6gIVuSBlfgQJgccOXNHZyeUx9?e=A3zpAL

[camargos88]

Hi @koorosh ,

Create a measure like this:

_All CourseNames =

VAR _AllCourseNames = CALCULATE(DISTINCTCOUNT(Sheet1[Course Name]), ALL(Sheet1))

VAR _PartnerCourseName = CALCULATE(DISTINCTCOUNT(Sheet1[Course Name]))

RETURN IF(_AllCourseNames = _PartnerCourseName, 1, 0)

and filter the visual:

[koorosh · Accepted solution]

Please let me check it.

Thanks

[koorosh]

Could you please send me an explanation for the measure?

[camargos88]

@koorosh ,

_All CourseNames =

VAR _AllCourseNames = CALCULATE(DISTINCTCOUNT(Sheet1[Course Name]), ALL(Sheet1)) 

VAR _PartnerCourseName = CALCULATE(DISTINCTCOUNT(Sheet1[Course Name]))

RETURN IF(_AllCourseNames = _PartnerCourseName, 1, 0)

CALCULATE(DISTINCTCOUNT(Sheet1[Course Name]), ALL(Sheet1)) -> gets the total number os coursers

CALCULATE(DISTINCTCOUNT(Sheet1[Course Name])) -> get the number of coursers by partner, once the partner column is on the table visual.

the if only compares if it's the same number to filter on the visual.