Forum Discussion

Icon for Resolver I rank

Resolver I

4 years ago

Solved

Measure does not get filtered by specific column

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
4 years ago
Hi I managed to solve my problem, it was due to a relationship misconfiguration.

Kind regards
Marta

6 Replies

PowerBI88
Resolver I
4 years ago
Hi I managed to solve my problem, it was due to a relationship misconfiguration.

Kind regards
Marta
amitchandak
Super User
4 years ago
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-Convert-to/ba-p/1476400
- PowerBI88
  Resolver I
  4 years ago
  Here is the diagram with the relationships.
  
  Let me know if you need further details.
  
  Thanks
  Marta
  - PowerBI88
    Resolver I
    4 years ago
    I've checked and I am not able neither to filter Baseline by the appName contained in RegressionelineareApplicazioni.
Anonymous
Not applicable
4 years ago
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

Related content