topic Re: Remove blank when Parameter is selected in DAX Commands and Tips

Remove blank when Parameter is selected

non23 — Thu, 09 Jan 2025 22:43:55 GMT

Hey guys,

I need your wisdom with a matrix visualization where I have used a parameter to control the rows, allowing users to select their desired view. My goal is to hide rows that contain "Blank Approver" values when Approver Parameter is selected.

Here’s the issue:

The "Blank Approver" rows represent rejected items, which should not be displayed if the user selects an "Approved" type.
The challenge is that the "Blank Approver" rows should not be shown regardless of the selected type (Approved or Rejected) when the parameter is applied.

I have attached an image to illustrate how the matrix should look when both the parameter and type are selected (as an ideal scenario). Is there a way to achieve this behavior where the "Blank Approver" rows are completely hidden when only the parameter is selected?

Parameter selected

Parameter and Type is selected

Re: Remove blank when Parameter is selected

non23 — Fri, 10 Jan 2025 01:59:00 GMT

I have managed to find a partial solution by following this link.

Unfortunately, I'm having issues with the Total as it's giving total of everything instead of the displayed values only.

Any help on the total issue would be appreciated!

Re: Remove blank when Parameter is selected

Anonymous — Fri, 10 Jan 2025 08:23:39 GMT

Hi non23,

Please check the following mesuare:

ShowRows = VAR SelectedField = SELECTEDVALUE(Parameter[Parameter Fields]) RETURN SWITCH( TRUE(), SelectedField = NAMEOF('MainTable'[Approver]) && SELECTEDVALUE('MainTable'[Approver]) = "Blank", 0, SelectedField = NAMEOF('MainTable'[Rejected by]) && SELECTEDVALUE('MainTable'[Rejected by]) = "Blank", 0, SelectedField = NAMEOF('MainTable'[Created by]) && SELECTEDVALUE('MainTable'[Created by]) = "Blank", 0, 1 )

Then filter the visual with ShowRows=1 to remove Blank value:

Result for your reference:

Best regards,

Joyce

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