Forum Discussion

sdiaz's avatar
sdiaz
New Member
4 years ago

Inverted filter slicer undesired summarization

Hi everyone, 

 

Intending to create a visual that displays the opposite of what is selected by a slicer, I have created a duplicate of the original table in which I have included the measure specified below:

Exclude 1 =
IF(
MAX(inv_reaccion[tiempo_reacción_minutos]) in ALLSELECTED('reacción usuarios Baires'[tiempo_reacción_minutos]) && COUNTROWS(ALLSELECTED('reacción usuarios Baires'[tiempo_reacción_minutos])) <> COUNTROWS(ALL('reacción usuarios Baires'[tiempo_reacción_minutos])),
1,
0
)
 Then I add this measure as a filter, saying it is equal to 0.
this measure works perfectly for a table in which I specify many fields, and I am able to select "don't summarize" for those fields, however I am not able to display the same result in a barchart where the measure does not work because automatically adds it up:
 

 

As you see the total displayed in the table is 116, however the barchart does not take the measure.

 

Hope someone could give me a hand.

 

Thanks beforehand,

 

Santiago

 


 

 

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    sdiaz , there is no option on bar visual for unsummarized, you will only see aggregated values. You need to have index column if needed and then have that as additional column on axis

  • sdiaz's avatar
    sdiaz
    New Member
    4 years ago

    Thanks for your answer, but I don't undersantand what is meant by index column nor adding that as additional column.

    Interpretating your answer I have also tried to create a measure that contains the count of ID tarea and I experience the same undesired result. Having this dynamic calculation depending on the slicer, does not work with creating a column, makes sense as a measure though.