Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to Solution.
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
Below is an example created in Exel. Can this be recreated in Power BI?
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
This worked great. Thank you for taking time out of your day to help an internet stranger. I appreciate it!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
111 | |
59 | |
57 |