@CJ_96601 No, it is in Power Query Editor, once you click on the "Edit Queries"
Proud to be a Datanaut !
I used this and it works..
@CJ_96601 Please update your Measure logic as below and use your Year field as a filter.
VAR _Total = SUMX(SUMMARIZE(Test219MaxSum,Test219MaxSum[BadgeNo],Test219MaxSum[Year],"Amount",MAX(Test219MaxSum[Amount])),[Amount])
Hi, thank you for your response.
The date (year) i am currently using is in another table.
Do i need to make a relationship between the two tables.
As of now, there is only one active relationship in power bi
Furthermore, if i make a relationship (Year), if i click year 2020, the result is zero , null, as there is no record in 2020. What i would like to have is to have 2019 sum even if i click 2020.
@CJ_96601 Yes it should have a relationship based on the Year field from which table you want to get it as a filter.
is it possible not having a relationships but create the filter by year (in the measure)?
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.