'QuickSight - count distinct of two columns

I need help with figuring out how to perform count distinct over two columns in QuickSight - find the number of unique combinations of values from two columns. Example below would result in 4

column1 center
apple 87
apple 87
banana 34
blueberry 45
blueberry 32
countdistinctamazon-quicksightdistinct-values


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

SQLite - SELECT DISTINCT of one column and get the others

Find first record of multiple values in single query

Why DISTINCT keyword is decreasing my search time and increasing performace in SQL Server

How to get distinct value and specific count from a query

Using Distinct in Aggregate Select query

DISTINCT with HASH MATCH (Flow Distinct) in SQL Server

DAX query with DISTINCT values, avoid repetition

SELECT DISTINCT, ORDER BY expressions must appear in select list - error when migrating from Oracle to Postgres

Get count distinct by nested objects from Elasticsearch

Is there a possibility in DAX to do a distinct over several columns?

solr distinct query I want only certain fields to be listed

Using SELECT DISTINCT to retrieve nearly identical array values in PGSQL

How to select distinct value

DB2 Querying a table for both DISTINCT and COUNT(DISTINCT)

Postgresql Multiple counts for one table