topic Asking for Help: Adding Measure as Filter in Power BI in DAX Commands and Tips

Asking for Help: Adding Measure as Filter in Power BI

Cris0410 — Fri, 31 Mar 2023 16:37:30 GMT

Hello!

I have a measure that calculates the performance of search terms in my campaigns. However, I want to add this as a filter, but I know that you cannot directly add a measure as a filter. Can anyone help me know how I can do this?

The formula for the measure is:

Bleeder: [Clicks] >= 10 and [Total Sales per Day] = 0

Untested: [Clicks] < 10, [Total Sales per Day] = 0

Unprofitable: ACOS > 0.25

Profitable**: ACOS between 0.15 and 0.25 < 0.25

Profitable: ACOS < 0.15

Thank you!

Re: Asking for Help: Adding Measure as Filter in Power BI

Wilson_ — Sun, 02 Apr 2023 20:34:31 GMT

Hi Cris,

Hopefully you find this 11 minute youtube video helpful. 😄

Re: Asking for Help: Adding Measure as Filter in Power BI

Anonymous — Tue, 11 Apr 2023 05:57:39 GMT

Hi Cris0410 ,

I created some data:

Here are the steps you can follow：

1. Enter data – create a table.

2. Create measure.

Flag = var _select=SELECTEDVALUE('Slicer_Table'[Group]) return SWITCH( TRUE(), _select="Bleeder"&& MAX('Table'[Clicks])>=10&&MAX('Table'[Total Sales per Day])=0,1, _select="Untested"&&MAX('Table'[Clicks])<10&&MAX('Table'[Total Sales per Day])=0,1, _select="Unprofitable"&&MAX('Table'[ACOS])>0.25,1 , _select="Profitable**"&&MAX('Table'[ACOS])<=0.25&&MAX('Table'[ACOS])>=0.15,1, _select="Profitable"&&MAX('Table'[ACOS])<0.15,1,0)

Measure = COUNTX( ALLSELECTED('Table'),[Index])

3. Place [Flag]in Filters, set is=1, apply filter.

4. Result:

Best Regards,

Liu Yang

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