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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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