Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Create report together for columns with equal strings

Hi, I hope you can help me. I have in my project, several columns whose data only contain the same type of string: always, almost always, rarely, never. I want to create a donut or pie chart that co...
olgad's avatar
olgad
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Suppose you have a table like that named Table


You shall create a table with statuses named Status

 

Create a relationship to Column1 and then inactive relationship to Column 2

Measure = Calculate(Count('Table'[Column2]), USERELATIONSHIP('status'[Column1], 'Table'[Column2]))+Count('Table'[Column1])