cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Row should be populated as Blank if a value Layer is Extraction

Hi,

I have a table as shown below:

LayerSource CountTarget CountDeltaDelta%
Ingestion123451234500.00
extraction 2345623456100
extraction 45674567100
integration 56755675100

 

when the Layer is equal to 'extraction' the the Delta% percentage is showing as 100.

I need to make Delta% column blank whenever the layer is Extraction.

The output should look like below:

LayerSource CountTarget CountDeltaDelta%
Ingestion123451234500.00
extraction 2345623456 
extraction 45674567 
integration 56755675100

used measure for Delta% column.

1 ACCEPTED SOLUTION
v-eachen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You could try the following measure:

Delta% =
CALCULATE (
    DIVIDE (
        SELECTEDVALUE ( 'Table'[Delta] ),
        SELECTEDVALUE ( 'Table'[Target Count] )
    ),
    FILTER ( 'Table', 'Table'[Layer] <> "extraction" )
)

Then select "Show items with no data".

2-1.PNG

Here is the result.

2-2.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

3 REPLIES 3
v-eachen-msft
Community Support
Community Support

Hi @Anonymous ,

 

You could try the following measure:

Delta% =
CALCULATE (
    DIVIDE (
        SELECTEDVALUE ( 'Table'[Delta] ),
        SELECTEDVALUE ( 'Table'[Target Count] )
    ),
    FILTER ( 'Table', 'Table'[Layer] <> "extraction" )
)

Then select "Show items with no data".

2-1.PNG

Here is the result.

2-2.PNG

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

DataInsights
Super User II
Super User II

Try this (where [Delta Measure] is your measure for calculating delta):

 

Delta % =
IF ( SELECTEDVALUE ( Layer[Layer] ) = "Extraction", BLANK (), [Delta Measure] )

 

Fowmy
Super User IV
Super User IV

@Anonymous 

Try:

=IF(Max(Table[Layer])="extraction",Blank(), [Delta%])

If you are satisfied with my answer, please mark it as a solution so others can easily find it.

Don't forget to give KUDOS ? to replies that help answer your questions


Subscribe to ExcelFort: Learn Power BI, Power Query and Excel


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors