The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I have defined a table this way:
Solved! Go to Solution.
Hi I managed to solve my problem, it was due to a relationship misconfiguration.
Kind regards
Marta
Hi I managed to solve my problem, it was due to a relationship misconfiguration.
Kind regards
Marta
Hi @PowerBI88 ,
Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file without sensitive data.
Best Regards,
Rico Zhou
@PowerBI88 , is appName in the table Baseline Gen-Febr-Mar or table joined with Baseline Gen-Febr-Mar , if yes, it filtering Baseline Gen-Febr-Mar ?
refer if needed
Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-C...
Here is the diagram with the relationships.
Let me know if you need further details.
Thanks
Marta
I've checked and I am not able neither to filter Baseline by the appName contained in RegressionelineareApplicazioni.
Hi @PowerBI88 ,
RegressionelineareApplicazoni(Fine Mese) = SUMMARIZE('Forecasting Applicazioni','Forecasting Applicazioni'[appName])
According to your measure, I think 'RegressionelineareApplicazoni(Fine Mese)' Table should be a Dimtable with De-duplicated appName from 'Forecasting Applicazioni' Table. So I am confused that why does the relationship between 'RegressionelineareApplicazoni(Fine Mese)'[appName] and 'Forecasting Applicazioni' [appName] is many to many. I think it should be one to many from 'RegressionelineareApplicazoni(Fine Mese)'[appName] to 'Forecasting Applicazioni' [appName].
Due to many to many relationship, you could only get to total sum from 'Baseline Gen-Febr-Mar' Table.
Here I suggest you to add some filter in your measure when you are calculating the sum of 'Baseline Gen-Febr-Mar'[Giornaliero].
Try this measure:
Budget =
VAR _DATEDIFF =
DATEDIFF (
DATE ( YEAR ( DataForecasting[DataForecasting Value] ), 1, 1 ),
DataForecasting[DataForecasting Value],
DAY
) + 1
VAR _SUM =
CALCULATE (
SUM ( 'Baseline Gen-Febr-Mar'[Giornaliero] ),
FILTER (
ALL ( 'Baseline Gen-Febr-Mar' ),
'Baseline Gen-Febr-Mar'[Applicazione]
= MAX ( 'RegressionelineareApplicazoni(Fine Mese)'[appName] )
)
)
RETURN
_DATEDIFF * _SUM
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.