Forum Discussion

marquesjef's avatar
marquesjef
Regular Visitor
2 years ago
Solved

Challenge Creating Cumulative Chart in Power BI with Distinct Token Count

In a table named 'token_ativos' with a column named 'created_at' for dates and a 'token_id' column containing the IDs of active tokens, where the 'created_at' column represents the creation date of t...
"DAX help"
Chart Help
Clustered Column Chart
  • ValtteriN's avatar
    ValtteriN
    2 years ago

    HI,

    I recommend checking out this article by SQLBI: Computing running totals in DAX - SQLBI
    Also in February Power BI udate visual calculations are now available in preview. Here is an example video about these: Power BI Feb 2024 Update: Visual Calculations Walkthrough! - YouTube

    As for your dax:
    var _mdate = max('Calendar'[date)
    return
    CALCULATE(COUNT('token_ativos'[ 'token_id']), ALL('Calendar'),'Calendar'[date]<= _mdate) 

    This assumes ou have calendar table and relation between it and your fact table.

    Here is an alternative with YTD.

    CALCULATE(COUNT('token_ativos'[ 'token_id']),DATESYTD('Calendar'[date])).

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

    My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/


Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi marquesjef ,

 

Hope everything is going well.

 

Please follow these steps:

 

1. This is the original data I created.

 

2. Create a measuring value, the DAX syntax is as follows:

Cumulative Total = 
CALCULATE(
    COUNTROWS('token_ativos'),
    FILTER(
        ALLSELECTED('token_ativos'),
        'token_ativos'[created_at] <= MAX('token_ativos'[created_at])
    )
)

 

3. Put the Created_at on the X-axis and Cumulative Total on the Y-axis.

 

At this point, you have realized your needs. If you have other questions, please contact me at any time.

 

The pbix file has been attached.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!