Forum Discussion

Turka89's avatar
Turka89
Helper I
6 years ago

if this column equal these values

Hi,   I have this scenario, if this column equals these values then show the result. However, there is a blank entry of which I want it deleted. Here is the DAX   column = IF(REQUISITION[Divisio...
General Comment
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, Turka89 

 

Based on your description, I created data to reproduce your scenario.

REQUISITION:

 

You may try the following two ways.

Way one:

You may create a calculated column and a measure as below.

 

Calculated column:
Result Column = 
IF(
    REQUISITION[Division] in {"IT","HR"},
    REQUISITION[Division]
)

Measure:
IsDisplay = 
IF(
    NOT(ISBLANK(SELECTEDVALUE(REQUISITION[Result Column]))),
    1,
    0
)

 

 

Then you need to put the measure in the visual level filter to display the result.

 

Way two:

You may create a measure as below.

 

Result Measure = 
IF(
    SELECTEDVALUE(REQUISITION[Division]) in {"IT","HR"},
    SELECTEDVALUE(REQUISITION[Division])
)

 

 

Result:

 

If I misunderstand your thoughts, please show us your sample data and expected result with OneDrive for business. Do mask sensitive data before uploading.

 

Best Regards

Allan

 

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