topic Measure based on a column B value which is equal to Column A Slicer Value in DAX Commands and Tips

Measure based on a column B value which is equal to Column A Slicer Value

kk_shp_user — Wed, 24 Apr 2024 11:52:19 GMT

I have two tables as shown below with a relationship on id column.

In Table_1, each id might have the same internal and external title (or) a different internal title to that of the extrernal title.

Lets assume A,B,C,D,E as the titles; So, an id 010 might have an internal title = 'A' and external title = 'E'

I am trying to get a measure that will give the SUM(sales) from Table_2 for ids based on external title while I have a slicer with internal title.

Example, I have a slicer for internal title. When I choose the internal title 'A', I want the measure to display the SUM(sales) for ids that have an external title 'A'.

I tried the below measure but it does not seem to work,

CALCULATE(SUM('Table_2'[sales]), TREATAS(VALUES('Table_1'[internal title]), 'Table_1'[external title]))

Re: Measure based on a column B value which is equal to Column A Slicer Value

Martin_D — Wed, 24 Apr 2024 13:18:01 GMT

Hi kk_shp_user ,

You need to also remove the filter from the internal title column, otherwise this still applies and your result includes only ids with internal title = A and external title = A.

CALCULATE(SUM('Table_2'[sales]), TREATAS(VALUES('Table_1'[internal title]), 'Table_1'[external title]),REMOVEFILTERS('Table_1'[internal title])))

Kind regards,

Martin

Re: Measure based on a column B value which is equal to Column A Slicer Value

kk_shp_user — Wed, 24 Apr 2024 14:32:57 GMT

Thanks I'll try this and report back.

Another query - if I use this measure inside another measure, will it still work?

Re: Measure based on a column B value which is equal to Column A Slicer Value

Anonymous — Thu, 25 Apr 2024 09:24:24 GMT

Martin_D Thanks for your contribution on this thread.

Hi kk_shp_user ,

What's your final expected result? Could you please provide some sample data (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

Another query - if I use this measure inside another measure, will it still work?

Best Regards

Re: Measure based on a column B value which is equal to Column A Slicer Value

Martin_D — Thu, 25 Apr 2024 11:23:13 GMT

Hi kk_shp_user ,

Yes inside of another measure it will still work, e.g., like this:

Some other measure = [Above measure] + [addition measure]

Kind regards,

Martin