Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Excluding some data after a certain date from dashboard

Let's say I want to exclude countries a, b, and c, after 01-01-2023 on a dashboard. so, data before that time appears for countries a, b, and c but after that time those countries show blank. One ...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

and if the user chooses 2022-01-01 until 2024-12-31, it has to show the data until 2023-01-01 and the rest blank. 

JirkaZ's avatar
JirkaZ
Icon for Solution Specialist rankSolution Specialist
3 years ago

I think something like this could work:

My Measure := 

SUMX('DimLocation', 
  IF('DimLocation'[Country] in ("Country 1", "Country 2"), 
  CALCULATE(SUM('FactTable'[SalesAmount]), DimDate[Date] < DATE(2023, 1, 1)), 
  SUM('FactTable'[SalesAmount])
)