topic Re: How to Remove blank data in matrix table in DAX Commands and Tips

How to Remove blank data in matrix table

Sugumaran31 — Mon, 17 Jun 2024 07:44:56 GMT

How to Remove blank data in matrix table. I need only show the value please refer to the image below

Daniel29195 — Mon, 17 Jun 2024 07:54:56 GMT

you have multiple approach

you can filter from the filter pane on the visual level, where the measure growth is not blank () .

another approach would be .

using a switch( ) in the code of the growth %,

and returning blank() if growth is blank() .

let me know if this helps.

Sugumaran31 — Mon, 17 Jun 2024 08:04:40 GMT

Daniel29195 But the filter pane on the visual is not working how do I use the switch function can you give me an example

Daniel29195 — Mon, 17 Jun 2024 08:08:17 GMT

so i think in the return of the growth % measure , you could write something like this .

growth % =

var numerator = [growth]

var denominator = [sales PYD]

return

switch (

true() ,

isblank( numerator) , blank() , divide ( numerator , denominator ) )

let me know if this helps.

rajendraongole1 — Mon, 17 Jun 2024 08:08:51 GMT

Hi Sugumaran31 - you can create a measure for Sales CYTD,Sales PYTD and growth as follows

SalesCYTD_NonBlank =
IF(
ISBLANK([Sales CYTD]),
BLANK(),
[Sales CYTD]
)

similarly

SalesPYTD_NonBlank =
IF(
ISBLANK([Sales PYTD]),
BLANK(),
[Sales PYTD]
)

and for growth too.once created the above measures for three fields, created a condition or flag with blank() or 1 for non blank metric

add the below measure in filter pane:

NonBlankMetrics =
IF(
ISBLANK([Sales CYTD]) && ISBLANK([Sales PYTD]) && ISBLANK([Growth]),
BLANK(),
1
)

In the Filters pane, drag the NonBlankMetrics measure to the Filters on this visual area.Set the filter condition to is not blank.

try the above approach and let know.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!