Filter out the measure based on the other measure text value

[Pavan_123456789]

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 

[v-weiyan1-msft]

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.

[lbendlin]

Please indicate the expected outcome based on your sample data.

[Pavan_123456789]

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])

[lbendlin]

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.

[Pavan_123456789]

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)

[lbendlin]

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.

[Pavan_123456789]

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

[lbendlin]

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

[Pavan_123456789]

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