Forum Discussion

uthall's avatar
uthall
Helper II
9 years ago
Solved

Card Total

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

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    9 years ago

    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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    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