topic Re: Filter out the measure based on the other measure text value in DAX Commands and Tips

Filter out the measure based on the other measure text value

Pavan_123456789 — Sat, 20 Jan 2024 17:16:00 GMT

Please help me I am trying to filter the data in 23 Qty Blank Values Only Based on the check Month Wise .

Check Month Wise = IF(ISBLANK([23 Qty]),"D",IF(ISBLANK([22 Qty]),"N",BLANK())) This is Measure
I have tried this dax 23 Qty Blank Values Only = If( check Month Wise=Blank(), 23 Qty,0) But its not working subtotal level its getting item code level only .

Please find the pbix file in the attached link: https://drive.google.com/file/d/1CCzoCSwThRgRSYaDvHCEOxtkJYQFffht/view?usp=drive_link
Ahmedx amitchandak 123abc Dangar332

Re: Filter out the measure based on the other measure text value

lbendlin — Sun, 14 Jan 2024 21:09:13 GMT

Please indicate the expected outcome based on your sample data.

Re: Filter out the measure based on the other measure text value

Pavan_123456789 — Fri, 19 Jan 2024 07:19:33 GMT

Hi lbendlin Thanks for your reply This is which i am expected result [23 Qty Blank] By using the sumx function which i am getting ,But i need without using the Sumx is it possible to filter the data?

23 Qty Blank = SUMX(SUMMARIZE('Financial Data (3)','Financial Data (3)'[Group],'Financial Data (3)'[SEGMENT],'Financial Data (3)'[PRODUCT CATEGORY],'Financial Data (3)'[CORPORATE CUSTOMER],'Financial Data (3)'[REPORTING COUNTRY],'Financial Data (3)'[PAC ITEM CODE],"Final",if(NOt (Check Month Wise = Blank(),[23 Qty],0)),[Final])

Re: Filter out the measure based on the other measure text value

lbendlin — Wed, 17 Jan 2024 23:52:37 GMT

While you can use a measure as a visual filter it is recommended that you don't attempt to measure a measure. Implement the complete business logic in a single measure.

Re: Filter out the measure based on the other measure text value

Pavan_123456789 — Fri, 19 Jan 2024 07:15:18 GMT

Hi lbendlin I have tried comlete business scenario in one measure without using the [check month wise] but still I am not able to filtering the Subtotal and Total level .Please help me

23 Qty Blank Values Only = var _23 Qty = calculate(sum(Financial data(QTY),
Financial data[Year]=2023
var _22 Qty = calculate(sum(Financial data(QTY),

Financial data[Year]=2022
Return
If(Not(Isblank(_23 Qty)&&Not(Isblank(_22 Qty),_23 Qty,0)

Re: Filter out the measure based on the other measure text value

lbendlin — Fri, 19 Jan 2024 15:22:04 GMT

Remember that in a table visual a measure is calculated twice. Once at the row level and once at the Totals level. "Think like the Grand Total" - use Summarize and apply your rules to each virtual table, even if that only consists of a single row.

Re: Filter out the measure based on the other measure text value

Pavan_123456789 — Sat, 20 Jan 2024 17:14:19 GMT

Hi lbendlin Thank you for the Replay

Can you give me clear solution where to use summerize ?

Please find the attached link for the Pbix file https://drive.google.com/file/d/1CCzoCSwThRgRSYaDvHCEOxtkJYQFffht/view?usp=drive_link

Re: Filter out the measure based on the other measure text value

lbendlin — Sat, 20 Jan 2024 16:29:07 GMT

I think what you want to show is the 2023 values, but only when there are also values for 2022?

Re: Filter out the measure based on the other measure text value

Pavan_123456789 — Sat, 20 Jan 2024 17:17:17 GMT

Yes I want to show the values when there also a values in 2022 also (But without using the sumx is it not possible ?)

Re: Filter out the measure based on the other measure text value

v-weiyan1-msft — Tue, 06 Feb 2024 05:04:12 GMT

Hi Pavan_123456789 ,

Could you tell us the reason that you don't want to use SUMX?
And whether lbendlin answer can help you get the desired result.
If his post helps, could you please mark his post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards,
Yulia Yan

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