topic Re: How to show specific value in DAX Commands and Tips

How to show specific value

noble10 — Wed, 25 Aug 2021 21:08:41 GMT

I would appericate it if someone can help me.

How do I create a DAX formula to only show specific value.

For example, I would like to create a Dax formula to only show branch 19, 22, 27 and exclude the rest of the branch. I do not want to use the exclude using the filter.

Re: How to show specific value

VahidDM — Thu, 26 Aug 2021 01:31:37 GMT

Hi noble10

Please try this measure:

Filtered Branch = CALCULATE ( FIRSTNONBLANK ( 'Table'[Location Name], "" ), FILTER ( 'Table', 'Table'[Branch] IN { 19, 22, 27 } ) )

the output will be as below:

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos !!

Re: How to show specific value

noble10 — Thu, 26 Aug 2021 17:12:28 GMT

Hi VahidDM,

Thank you so much for your help! I unfortunately was not able to select the measure as a slicer. Not sure why?

Re: How to show specific value

VahidDM — Fri, 27 Aug 2021 00:07:54 GMT

Hi noble10

Try to add a column with this code to your table:

IF you want to have Branch No. in your slicer:

Filtered Branch = if('Table'[Branch] in{19,22,21},'Table'[Branch])

If you want to have a Location Name in your slicer:

Filtered Branch = if('Table'[Branch] in{19,22,21},'Table'[Location Name])

Then add Filtered Branch column to your slicer.

Did I answer your question? Mark my post as a solution!

Appreciate your Kudos !!

Re: How to show specific value

noble10 — Mon, 30 Aug 2021 16:11:41 GMT

Hi VahidDM

I tried the instruction above but it dosen't seem to work.

Re: How to show specific value

VahidDM — Mon, 30 Aug 2021 23:51:31 GMT

Hi noble10

Could you please share a screenshot from the error you ean into here? or share the sample of your PBIX (power bi) file here to be able to work on it.

Appreciate your Kudos !!

Re: How to show specific value

wdx223_Daniel — Tue, 31 Aug 2021 03:51:28 GMT

you can add a IF function in your measures, such as

IF(SELECTEDVALUE(table[Branch]) IN {19,22,27},[old measure])

Re: How to show specific value

noble10 — Tue, 31 Aug 2021 15:36:28 GMT

Hi VahidDM

I message you the link to the PBIX (power BI) file. Thank you.

Re: How to show specific value

noble10 — Tue, 31 Aug 2021 15:40:59 GMT

Hi wdx223_Daniel

I tried that and it doesn't seem to work either.

I was unable to generate a slicer after creating the measure.