Block the result of a data filtering

[Anonymous]

I would like to filter data from an array and make the result static, Meaning no matter what filter i would still do on this data, the previous result will not be affected.

[v-xiaotang]

Hi @Anonymous 

Have you solved this problem? If yes, could you kindly accept the answer helpful as the solution (or kindly share your solution ). so the others can find it more quickly.
really appreciate!
Any question, please let me know. Looking forward to receiving your reply.

Best Regards,
Community Support Team _Tang

[Anonymous]

Hello

Sorry but the answers didn't solve my problem. I'm still thinking about a solution to fix it.

Thank you for your message.

Best regards,

[v-xiaotang]

Thanks for your reply, is there anything I can help you with? @Anonymous 

Best Regards,

Community Support Team _Tang

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

[v-xiaotang]

Hi @Anonymous 

how about using function ALL() in your DAX expression when calculating Nombre de N° d'Incident? This function is useful for clearing filters and creating calculations on all the rows in a table.

OR use ALLEXCEPT(), it can remove all context filters in the table except filters that have been applied to the specified columns.

Syntax
ALL( [<table> | <column>[, <column>[, <column>[,…]]]] )

Syntax
ALLEXCEPT(<table>,<column>[,<column>[,…]])

-

if Nombre de N° d'Incident is measure, try like this

calculate(sum(table[count]),allexcept(table,table[Période]))

Best Regards,

Community Support Team _Tang

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

[Anonymous]

Can you please help me do this? I tried to block the filter result with the "modify interaction" fonctionnality but when i filter the data again with a different filter it always changes my first result 

[tex628]

Hi @Anonymous , 

Can you provide an image of how you're presenting your data?

Making a visual static is not very difficult, but can be done in a few different ways depending on how you intend to show the result. 

/ J

[Anonymous]

I have filtered "Nombre de N d'incident" using "periode" and i would like the result to remain static. But when i use the filter "test" or any other filter, it changes the result i have on.

[Pragati11]

HI @Anonymous ,

Not sure what you mean by filtering data above. Add more details to your query:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati

[Anonymous]

I have filtered "Nombre de N d'incident" using "periode" and i would like the result to remain static. But when i use the filter "test" or any other filter, it changes the result i have on.

[Pragati11]

Hi @Anonymous ,

I think you need to look into EDIT INTERACTIONS in Power BI:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Thanks,

Pragati

[Anonymous]

I nave already tried to block the filter result with the "Edit interaction" fonctionnality but when i filter the data again with a different filter it always changes my first result 

[tex628]

You need to select the "Test" slicer and the toggle off the interaction on the "Nombre" visual. Then you will need to repeat this with all slicers that you don't want to interact with "Nombre".