Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Aggregated Total based on Filter

This is the filter that I have.       This is my Chart.                     I just want to get the Aggregated Total of all the Opportunity even when it has no filter or the...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Please check if this is what you want:

    Measure =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Month] <= MAX ( 'Calendar'[Month] ) )
)

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello amitchandak this is the sample data.

 

In Oct 2020 there is 1 row.

In Nov 2020 there is 2 row.

In Dec 2020 there is 2 row.

In Jan 2021 there is 1 row.

 

I want to show this kind of Chart that is responsive using a slicer.

 

Thank you.

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    Please check if this is what you want:

    Measure =
CALCULATE (
    COUNTROWS ( 'Table' ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Month] <= MAX ( 'Calendar'[Month] ) )
)

     

     

    Best regards

    Icey

     

    If this post helps, then consider Accepting it as the solution to help other members find it faster.