topic Re: Filter the values In one measure based on the measure result in Matrix Table in DAX Commands and Tips

Filter the values In one measure based on the measure result in Matrix Table

Pavan_123456789 — Wed, 13 Dec 2023 07:24:57 GMT

I am trying to filter out the values based [Check Month Wise] Measure {

Check Month Wise = IF(ISBLANK([First Month Qty]),"D",IF(ISBLANK([Sec Month QTY]),"N",BLANK()))}
I am getting blank Total First Month Qty Duplicate whn i kept [Check Month Wise]=Blank() I need only Blank() values in Total as well as sub total
Greg_Deckler vicky_

Re: Filter the values In one measure based on the measure result in Matrix Table

Pavan_123456789 — Wed, 13 Dec 2023 09:42:59 GMT

Hi Please find the attached pbix file in the drive link

https://drive.google.com/file/d/1dJTXsSg_SHyRO1oh0DJzH-D8wk7dlLzG/v...

Re: Filter the values In one measure based on the measure result in Matrix Table

Anonymous — Fri, 15 Dec 2023 05:30:13 GMT

Hi Pavan_123456789 ,

Sorry but when I open the link, it shows this message:

Best Regards,
Dino Tao

Re: Filter the values In one measure based on the measure result in Matrix Table

Pavan_123456789 — Mon, 18 Dec 2023 06:40:31 GMT

Hi Anonymous

Please find the file in this link
https://drive.google.com/file/d/1YJQd6ON1CJrUMfFgxsaSU0KPXQ0QPOlC/view?usp=drive_link
Here i have two measures [current year qty] and [previous year qty] based on the check measure i am trying to filter out the data D,N from the current year qty in [current year with blank only ] but in the sub totals is not excluding

{Current Month Only blank = IF([Check]=BLANK(),[Current Month Qty],0)}

Please help me this is urgent requirement