Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Mohan_sc
Frequent Visitor

Slicer for Running Total

Hello All,

I'm working on on of the Running total Project. These are my below mesures.

zCount TDD Planned running total in Date =
VAR LastCompDate = CALCULATE( LASTDATE('Burndowns (Append)'[AxTDD DueDate]),ALL('Burndowns (Append)'))
Return
If( SELECTEDVALUE('Date'[Date]) > LastCompDate, BLANK(),
CALCULATE(
    [zCount TDD Planned],
    FILTER(
        ALLSELECTED('Date'[Date]),
        'Date'[Date] <= MAX('Date'[Date])
    )
))
 
 
Issues -
When I'm  applying slicers Running total not stoping for MAX date of column. Please see below
Mohan_sc_0-1659467497144.png

 

3 REPLIES 3
v-jianboli-msft
Community Support
Community Support

Hi @Mohan_sc ,

 

I can't reproduce your problem, the slicer and date works fine in my side. Could you please share me with your pbix file after removing sensitive data?

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-jianboli-msft
Community Support
Community Support

Hi @Mohan_sc ,

 

Based on your description, I have created a simple sample:

vjianbolimsft_0-1659691494201.png

Here is the measure:

 

Measure = 
var _a = CALCULATE(LASTDATE('Burndowns (Append)'[Date]),ALL('Burndowns (Append)'))
return IF(SELECTEDVALUE('Burndowns (Append)'[Date])>_a,BLANK(),CALCULATE(MAX('Burndowns (Append)'[A]),FILTER(ALLSELECTED('Date'[Date]),'Date'[Date]<=MAX('Date'[Date]))))

 

Output:

vjianbolimsft_1-1659691554058.png

vjianbolimsft_0-1659692702950.png

 

Maybe I misunderstood? If this is not what you want, can you please share more details to help us clarify your scenario?

Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.

 

Refer to:

How to provide sample data in the Power BI Forum

How to Get Your Question Answered Quickly

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thnk you for your respond.. please go through below
This is my Data table

Mohan_sc_0-1659702279489.png

This is my Intiative slicers

Mohan_sc_1-1659702314858.png

 

This is my Line chart

Mohan_sc_2-1659702370614.png

 

It's work fine without slicers. But when you applying slicers the count not stoping for end of the maxium date.Please see below. It need to be stop 9/22/2023

Mohan_sc_3-1659703107125.png

Mohan_sc_4-1659703181416.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.