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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
BIlix
Helper II
Helper II

Measure shows wrong total, does not take into account all Months

Hello Community,

 

I created a Measure which forecast values for Months which currently do not have any Data.

 

In a Matrix it shows the correct results for exisiting months(current value of a measure) and for months, where the Measure is currently blank. 

But the total is wrong. It still only show the total for the existing months.

 

The measures are based on my facttable. The Fact table currently has data until end of August. There are no rows for Months after august. Also when i put the Measure as a Column in my Date Table, it only returns the results for months which are available in the Fact Table.

BIlix_0-1694014340965.png

 

1 REPLY 1
some_bih
Super User
Super User

Hi @BIlix there is no definition for relate measure or some other details. 

Still, if you want to control / limit figures "up to the last date of your fact table" use below logic for your measure
CALCULATE(
      MAX(Your Fact bale[Related Date Column]),

       REMOVEFILTERS()
)

Did I answer correctly? Kudos appreciate / accept solution.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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