Graph the cumulative quantity of occurrences of a string over time

[zp7893]

I'd like to create a line graph that shows total cumulative count of occurences of a string (pc_name).

I can find a lot of exampels of this with numbers.  But I can't figure it out with a string.  I'm new to power BI, and am getting a little frustrated.

Any advice?

[Vvelarde]

@zp7893

Hi can you show us What is the expected result?

[zp7893]

Below is an example created in Exel.  Can this be recreated in Power BI?

[Vvelarde · Accepted solution]

@zp7893

Hi, Lets try with:

1. Create a New Table With Distinct IDs

Modeling - New Table

Tableid = DISTINCT(Table1[ID])

2. Create a measure:

Count of pc_name running total =
CALCULATE (
    COUNTA ( 'Table1'[pc_name] ),
    FILTER ( ALLSELECTED ( 'Tableid'[ID] ), Tableid[ID] <= MAX ( Tableid[ID] ) )
)
    + 0

3. In a Matrix Visual : 

ID from Table ID 

4. Ready

VV

[zp7893]

This worked great.  Thank you for taking time out of your day to help an internet stranger.  I appreciate it!