cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CJ_96601
Helper V
Helper V

YE data

Need help to get a constant YE data that is not affected by Filter:

 

Measure = (CountYE + Counttodate)/2

 

Based on below table, countYE for 2021 must be 24  even if i select year 2022 month Aug. 

 - countYE for 2021 must be 24  even if i select year 2022 month Jan and so on and so forth. 

 

his is without using edit interaction. 

 

Example: 

 

YearMonthCount
2021Jan2
2021Feb2
2021Mar2
2021Apr2
2021May2
2021Jun2
2021Jul2
2021Aug2
2021Sep2
2021Oct2
2021Nov2
2021Dec2
2022Jan5
2022Feb5
2022Mar5
2022Apr5
2022May5
2022Jun5
2022Jul5
2022Aug5

 

 

Thanks

1 REPLY 1
ryan_mayu
Super User
Super User

@CJ_96601 

what about turn off the visual interactions?

Change how visuals interact in a report - Power BI | Microsoft Docs

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors