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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Rytis
Frequent Visitor

Help with Measure to exclude values assigned to the blank dates

Hi,

 

I am calculating the budget in relation to the dates. Some dates are blank but have values, which I don't want to show on my visual, it does not work well when I use the filter and it still appears in my cumulative values. Thus, I want to exclude them from my measure:

 

Budgeted value total for Plan to award =
CALCULATE(
    SUM('Procurement Tableau AO'[Budgeted value]),
    ALLSELECTED('Procurement Tableau AO'[Plan to award])
)

 

"Budgeted values" field contains the values and "Plan to award" field contains the dates.

 

How can I exclude the values assigned to to blank dates from my measure?

 

Please see below:

 

Rytis_0-1675854733702.png

 

Thanks,

Rytis

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Rytis , use budget measure as visual level filter , that will remove dates that do not have budget

 

if you want to show you add +0 or use this option

 

Show item with No data new.pngShowItemwithoutdata.JPG

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Rytis , use budget measure as visual level filter , that will remove dates that do not have budget

 

if you want to show you add +0 or use this option

 

Show item with No data new.pngShowItemwithoutdata.JPG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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