Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Slicer / Measurement / Matrix

Hello,

 

i have on one page a matrix with different measurements.

Well if i use a slicer (here changing the period) - the values (in measurements) doesn´t changed at once, they only change if i "refresh" the page by changing to another page an go back.

 

What will be the right solution?

Thx

Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Anonymous ,

     

    You may use ALLSELECTED function instead of ALL function in your measures to take effect of the filter selections of slicer visual, like DAX below.

     

    Measure1= CALCULATE(SUM(Table1[Sales]),ALLSELECTED([Slicer field]))

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Amy,

     

    maybe You´re right, but this doesn't explain me, why a part works correct and another not.

     

    My "solution" at now was - copy to past matrix from old version in the new one... and now it works.

    Well, as You see, there must be a connection between slicer and matrix update.

7 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Anonymous ,

     

    First thing whatever information you have shared is not sufficient to answer your question.

    Please add details like what measures are created, screesnshots on sample data, etc.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, 

       

      well, it doesn´t depend on measurents or on slicer. Cause the slicer works and measurement to, cause i get the information back, when i "refresh" the page by go to next and back.

       

      So it depends on the question "why the slicer doesn´t change the actualisation directly". Btw. in other matrix on the same page it works correctly.

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Anonymous ,

         

        You will need to provide additional details here as no one in the forum can help you if you don't share details.

         

        Thanks,

        Pragati