Is there a way to display column that is unfiltered in a visualization that has other filters?

[FarmerKenny]

I have this visual and  to make the Healthy_People_Objective_Target column to be unfiltered and to appear at the same level ast the first row ( unfiltered by the County Column Filter) .  Can someone please share with me how to do that? 

Example of Healthy_People_Objective_Target that needs to be a column next to the filtered California and SLO columns

[Anonymous · Accepted solution]

Hi @FarmerKenny ,

Please have a try.

Create a measure.

meaasure =
CALCULATE (
    SUM ( summary_Sheet[Healthy_People_Objective_Target] ),
    FILTER (
        ALL ( summary_Sheet ),
        summary_Sheet[Health_Indicator_Desc]
            = SELECTEDVALUE ( summary_Sheet[Health_Indicator_Desc] )
            && summary_Sheet[County] = SELECTEDVALUE ( summary_Sheet[County] )
    )
)

Best Regards

Community Support Team _ Polly

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

[Anonymous]

Hi @FarmerKenny ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure = CALCULATE(SUM(summary[Healthy_People_Objective_Target]),FILTER(ALL(summary),summary[Health_Indicator_Desc]=SELECTEDVALUE(summary[Health_Indicator_Desc])))

If I have misunderstood your meaning, please provide more details about your desired output.

Best Regards

Community Support Team _ Polly

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

[FarmerKenny]

Whoops the example below is also filtered by County. Here are the "unfiltered by County column" values that the column should contain. 

Healthy People Objective Target
72.8
43.6
20.4
22.6
18.6

[FarmerKenny]

Thanks, but that solution does not work.  Please refer to the desired results tab of the excel document in the Google drive URL.  The new unfiltered column should have this result.  (This is pic of a seperate visualization that is unfiltered for the County column.  All other filters are valid.  Can you please try again?

[parry2k]

@FarmerKenny thanks for sharing the files, one thing is not clear what output you are looking for, can you add another sheet in the excel file and explain the output? Thanks!

[FarmerKenny]

Here is a quick markup of what I want to do. 

[FarmerKenny]

I just sent a v2.pbix file up to the Google Docs folder that contains the v4 version. This v2 version shows the columns just like the "Desired Results" tab on the Source Excel Document that contains the source data. 

[FarmerKenny]

I just added the Desired Results tab to the Excel Doc that I sent to you on Google Drive. It should help. 

[FarmerKenny]

See the Desired Results Tab for the desired columnar format and values.  The first to colums are filtered by County, which I don't want filtered on the Third column.  Thanks for  your help. @FarmerKenny 

[parry2k]

@FarmerKenny to be very honest your question is not very clear, here is what I would recommend. put sample data in an excel file with the expected output, and share using one drive/google drive.

[FarmerKenny]

@parry2k , I just got permisson to share it.  Will post the link to the excel file and the .pbix file that I am working to solve this issue on. 

[FarmerKenny]

@parry2k , Here is the link to Google Drive:

https://drive.google.com/drive/folders/1YNz5E8yzvxFoqsq3RaVvSRkj3SWVLuNo?usp=sharing

[FarmerKenny]

@parry2k , I am requesting permisson to share this data now. It may be HIPPA protected, and if it is, I can't share it. If it is HIPPA protected, could I send you a Teams request?

[FarmerKenny]

So far, none of the proposed solutions have worked to solve this issue.  I gave my customer this work-a-round, but she rejected it. However it shows the correct subtotals by County.   She wants the Sum Rate/Percentage column filtered by the County, but not the Sum of the New Column for Target column, she wants it to be a sum of all values for the table. 

[FarmerKenny]

My configuration looks like this: 

[FarmerKenny]

@parry2k , I did excactly as you instructed above, in a few differenct permetations, and still it fails to work.  I tried it as  Measue and as a new column  using this syntax:  

Measure for Target = CALCULATE ( SUM( 'summary'[Healthy_People_Objective_Target] ),

REMOVEFILTERS ( 'summary'[County])

)

but I don't wish to SUM that column, just display it's values. 

[parry2k]

@FarmerKenny you need to add a

Measure for Target = 
CALCULATE ( SUM ( YourTable[Healty_People_Objective_Target ), 
REMOVEFILTERS ( YourTable[Column Name used on the columns in the matrix visual] )
)

and then use the above measure in the matrix visual and put this as a first measure in the value section so that it is right under the country name.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

measure for target which will be something like this:

[FarmerKenny]

And would be positioned  next to the CALIFORNIA and San Luis Obispo columns in the first picture. 

[FarmerKenny]

 So that it looks like this, as a primary (unfiltered)  column. 

[FarmerKenny]

Effectively, I want to promote the Healthy_People_..... column up one level so that it stands next to (not under) the County Columns.