topic Re: Filtering a DAX measure by a column in DAX Commands and Tips

Filtering a DAX measure by a column

Anonymous — Wed, 02 Feb 2022 01:14:48 GMT

Hi all

I have a measure giving me the profit margin of all course intakes (when grouped together). The intakes are listed in a column called Intakes. There are about 144 and increases if new course intakes are added. I add the measure to a visual, along with the years and months but when I add the Intakes, I don't get individual profit margins for each intake, it still adds up the total profit margin. How do I get this to work? I need to see the profit margin per intake. Any and all assistance is greatly appreciated. I am just getting started with DAX.

This image is what is looks like:

Hope this makes sense.

Thank you.

Karen

Re: Filtering a DAX measure by a column

amitchandak — Wed, 02 Feb 2022 02:49:48 GMT

Anonymous , is your data model working on the intake date or some other date. Ideally for profit margin based on instake date intake date should also join to date table. If there is more than one date and join is inactive, you can use userelationship in the measure

https://radacad.com/userelationship-or-role-playing-dimension-dealing-with-inactive-relationships-in-power-bi

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Filtering a DAX measure by a column

Anonymous — Wed, 02 Feb 2022 03:06:06 GMT

Thanks amitchandak. I don't think that is it as I do have the date table joined to the intake booking date in my model.

Re: Filtering a DAX measure by a column

amitchandak — Wed, 02 Feb 2022 03:45:52 GMT

Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Re: Filtering a DAX measure by a column

Anonymous — Thu, 03 Feb 2022 01:16:12 GMT

Sure will. I won't be able to get to that until later tonight so will post some then. Thanks amitchandak