Card Total

[uthall]

Hello,

IU have a table with a column showing values of either "Yes" or "No" with assocuiated date periods

A period will have multiple "Yes" entries.

I want a card to show the toal number of "Yes" entries, but grouped by period.

So for example, if period 1 has 4 rows, with yes each time, then i want a count of 1, not 4

If period 2 has 10 rows, and 10 yes, then  i want a count of 1

Between the 14 rows, i expect a total of 2.

Its essentialy a distinctcount per period.

How would i get this value into a card?

I want to display ther total

[v-yulgu-msft · Accepted solution]

Hi @uthall,

Based on your source table. you should create a calculate table:

Table =
ADDCOLUMNS (
    SUMMARIZE (
        'Card Total',
        'Card Total'[Column1],
        "CountofYes", DISTINCTCOUNT ( 'Card Total'[Column2] )
    ),
    "CountPeroid", IF ( [CountofYes] = 1, 1, 0 )
)

Then, add this measure in card visual to display the total value.

Total = SUM('Table'[CountPeroid])

Thanks,
Yuliana Gu