Solved: Filter ALL measure and filter only one row

Anonymous · ‎06-24-2021

Hi!

Hopefully somebody can help me with this issue!

I want to show the measure value [-240.616,49] only on the row with 9999. I think I need to combine the Filter and ALL function, but I can get it to work...help needed! Thanks in advance.

amitchandak · ‎06-24-2021

@Anonymous , create a measure like using the one you have

if(Max(Table[Level1]) ="9999", [Sum 9999], blank())

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

View solution in original post

amitchandak · ‎06-24-2021

@Anonymous , create a measure like using the one you have

if(Max(Table[Level1]) ="9999", [Sum 9999], blank())

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Filter ALL measure and filter only one row

Helpful resources

Fabric certifications survey

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly