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 ...
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

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