Forum Discussion

vannipart's avatar
vannipart
Frequent Visitor
9 years ago
Solved

Conditional filtering based on specific row value, with several dashboards

Hello I have a list of countries and then there is a special "all" also included, which is made for one specific visual, to show the overall value.  Other visuals in the dashboard don't have "a...
Need Help
  • vannipart's avatar
    vannipart
    9 years ago

    Hello Xiaoxin, 

     

     

    Thank you for you effort!
    I found a way to work around it, it is not perfect but looks like that. 

     

    Measure = if(iscrossfiltered([averageAge]),FIRSTNONBLANK(age[averageAge],

    [averageAge]),CALCULATE(FIRSTNONBLANK(age[averageAge],[averageAge]), FILTER(age,[country] = "All")))

     

     

    I hidde "all" from slicer view, so when nothing is selected then the averageage is 39 and the unit is what it should be and if a country is selected then numbers will be correct.

    Thank you again for your effort!


    Kaarel 

vannipart's avatar
vannipart
Frequent Visitor
9 years ago


Here are three situations situations, that i have.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi vannipart,

 

Can you please share a sample pbix file to test? Based on your screenshot, it is hard to reproduce your issue.

 

Regards,

Xiaoxin Sheng

  • vannipart's avatar
    vannipart
    Frequent Visitor
    9 years ago

    Hello, 

     

     

    I made an example table. So the right combinationm, when slicer nothing is selected would be age=39 and unti 19872873 and if all is selected then age should be 39 and 19872873. Of course by chaning country the numbers will go in an correct way. 


    https://pictureskk.blob.core.windows.net/pic2/EXAMPLEALL.pbix

    Best of luck, 
    Kaarel

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi vannipart,


      For your scenario, the simple way is use current table to create new table with summary row, then build relationship to country table and use new table as the source of table visual.

      Table = UNION('NO ALL DATA',ROW("country","ALL","unit",SUM('NO ALL DATA'[unit])))

       

      Regards,

      Xiaoxin Sheng

      • vannipart's avatar
        vannipart
        Frequent Visitor
        9 years ago

        Thank you Xiaoxin!

        Creating special table for "all" is one option, but it isn't solving my problem if nothing is selected. I have several different visuals which all would require this and automatically being updated all the time. 

         

         

         

        Thank you very much.

         

        Kaarel