Measure does not get filtered by specific column

[PowerBI88]

Hi,

I have defined a table this way: 

RegressionelineareApplicazoni(Fine Mese) = SUMMARIZE('Forecasting Applicazioni','Forecasting Applicazioni'[appName])

then I created a measure on the same table this way: 

Budget = calculate((DATEDIFF ( DATE ( YEAR ( DataForecasting[DataForecasting Value] ), 1, 1 ), DataForecasting[DataForecasting Value], DAY ) + 1)*sum('Baseline Gen-Febr-Mar'[Giornaliero]))

I am not able to filter "Budget" measure by column appName which is on the same table.

can you provide me some help on how to solve this issue?

Thank you

Kind regards

Marta

[PowerBI88 · Accepted solution]

Hi I managed to solve my problem, it was due to a relationship misconfiguration.

Kind regards

Marta

[Anonymous]

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

[amitchandak]

@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...

[PowerBI88]

Here is the diagram with the relationships.

Let me know if you need further details.

Thanks

Marta

[PowerBI88]

I've checked and I am not able neither to filter Baseline by the appName contained in RegressionelineareApplicazioni.

[Anonymous]

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.