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

[Anonymous]

Hi,

I have a table as shown below:

Layer	Source Count	Target Count	Delta	Delta%
Ingestion	12345	12345	0	0.00
extraction		23456	23456	100
extraction		4567	4567	100
integration		5675	5675	100

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:

Layer	Source Count	Target Count	Delta	Delta%
Ingestion	12345	12345	0	0.00
extraction		23456	23456
extraction		4567	4567
integration		5675	5675	100

used measure for Delta% column.

[v-eachen-msft · Accepted solution]

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".

Here is the result.

[DataInsights]

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

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

[Fowmy]

@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