Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hey Community,
I have the following time line chart to track the running totals by day for my data:
As you see for the closed cumulative is working fine but for the created one its not adding up and its showing the value for that specific day. The only difference between the 2 is that on the closed im just counting all whilst on the created as the data is repeated I want to only count distinct values from another column for example:
As this is the same case id, i want this to only count as 1 ticket and not 5 tickets. The measures i created are the following:
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |