Add a custom total column (custom query), with "See records" option

[Let]

Hi,

I want a matrix like this in my dashboard, but I can't figure out how to achieve it.

        |   XXX   |   YYY   |   ZZZ
----------------------------------------
Total   |   832   |   438   |   255
----------------------------------------

For the column XXX, the equivalent query in Excel would be: COUNTIF(AX = Complete and AY = Done)

Any ideas?

My first try:

With this code, my table has a new column named Total Stats, and tells if the current row is XXX, YYY or ZZZ. The matrix visualization does all the rest.

The only problem of this is that a row can't be XXX and YYY the same time, however, I need it to be so (I want a row to be considered as XXX and YYY for example).

My second try:

I created a new static table using #table(...) with 3 columns XXX, YYY and ZZZ and then display it in the dashboard.

The only problem of this one is the unability to right-click a cell to see the matching records (this is a required feature):

[v-sihou-msft]

@Let

To get your expected result, you must have records like: 

Total   XXX   832
Total   YYY   438
Total   ZZZ   255

in your source table. 

So you may add a Total column first, then unpivot it to make this Total column appended as rows. 

Regards,

[DAX0110]

Hi @Let, you may want to consider unpivoting your source table.