Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

All Not Ignoring Filter Slicer

https://rapidshare.io/57h/ex.pbix    Goodmorning everyone,   I disturb you this time to know the possibility of keeping values in the table on power bi even after selecting a special filter.   ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi Anonymous ,

    Try the following formula:

    Measure = 
var tab = 
    SUMMARIZE(
        'Date',
        'Date'[CodiceDivisione],
        "_sum",SUM('Date'[ValoreNetto])
    )
return 
    CALCULATE(
        'Date'[test],
        FILTER(
            tab,
            'Date'[CodiceDivisione] = 'Date'[CodiceDivisione]
        )
    )

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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