Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Pavan_123456789
Helper III
Helper III

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

Pavan_123456789_1-1702451949145.png

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_ 

3 REPLIES 3
Pavan_123456789
Helper III
Helper III

Hi Please find the attached pbix file in the drive link

 
 
Anonymous
Not applicable

Hi @Pavan_123456789 ,

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

vjunyantmsft_0-1702618179948.png


Best Regards,
Dino Tao

Hi @Anonymous 

Pavan_123456789_0-1702881397564.png

 


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 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.