Cumulative plot filtering error

[gustavoamolina]

Hello!

I have some cumulative plots in my dashboard but when I try to filter it does not work. 

Every time when there is no data to be added the measure place the minimum value intead of the cumulative value.

This is the measure that I've used: 

cumulativetimepercycle = CALCULATE(COUNT(Hood[Time of usage]),FILTER(ALL('Hood'),Hood[Time of usage]<=MAX(Hood[Time of usage])))

[v-yiruan-msft · Accepted solution]

Hi @gustavoamolina ,

If I understand correctly, it seems that the culmulative values not display correctly when apply the filter. Am I right? Please update the formula of measure [cumulativetimepercycle] as below and check if it can return your expected result...

cumulativetimepercycle =
CALCULATE (
    COUNT ( Hood[Time of usage] ),
    FILTER (
        ALLSELECTED ( 'Hood' ),
        Hood[Time of usage] <= SELECTEDVALUE ( Hood[Time of usage] )
    )
)

If the above one didn't help you, please provide some raw data in your table 'Hood' with Text format, the filter settings and your expected result with backend logic and special examples. It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards