Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Cumulative total- Measure

Hi All,

 

i need to create the cumuative total using measure in matrix visual. But the cumulative total has to change based on the filter i applied. it is working fine when i use slicer. 

But my problem is when i filter in filter pane , cumuative total showing wrong.

Please guide me how to handle this.

above screen shot for cumulative total working file when i use slicer.

measure

 

Cumulative_Variance =
var client=[Variance_Period]
var total =CALCULATE([Variance_Period],FILTER(ALLSELECTED('Employee list'[Client]),[Variance_Period]<=client))
return
total
--------------------
 

 for the above screen shot, cumuative total not correct. here i have filtered variance measure >0 in filter pane ( highlighted in blue pen ).

how do i achieve this to get the correct cumuative total

 

Thanks

 

Mahavishnu

 

 

 
 
 
 

 

 

 

Thanks

 

Mahavishnu

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous ,

     

    Through my testing, using the slicer gives the same results as using the filter pane. 

    Please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

     

    Best Regards,

    Neeko Tang

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

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

    Share the download link of the PBI file and show the expected result very clearly there.