The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
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.
Proud to be a Super User!
User | Count |
---|---|
14 | |
12 | |
7 | |
6 | |
5 |
User | Count |
---|---|
28 | |
18 | |
13 | |
7 | |
5 |