In PowerBI desktop I have a chart visual which is based on a measure. The measure is calculated from a direct query data connection to an Azure Database for PostgreSQL.
Within this report I have various slicers, such as a slicer to display visuals only for players from a specific game, from a specific group and players which have been created in a specific month.
The visual in question seems to have an issue with the month selection slicer. The visual is displaye correctly when the date slicer is selected to display data from the past 4 months (i.e. July, August, September, October 2020.) but it fails to display when the required month is earlier than that (i.e. June 2020 or earlier).
There are two visuals which fail to display, both of which depend on this following measure:
CummulativePlayers =
CALCULATE(
COUNTROWS ('public dim_players'),
FILTER (
ALLEXCEPT('public dim_players', 'public dim_date'[date]),
'public dim_players'[creation_date] <= MAX('public dim_date'[id]) &&
(
ISBLANK ( 'public dim_players'[deletion_date] ) ||
'public dim_players'[deletion_date] > MAX('public dim_date'[id])
)
),
USERELATIONSHIP('public dim_players'[creation_date], 'public dim_date'[id]),
USERELATIONSHIP('public dim_players'[deletion_date], 'public dim_date'[id]),
USERELATIONSHIP('public dim_players'[game_id], 'public dim_games'[game_id]),
USERELATIONSHIP('public dim_players'[group_id], 'public dim_groups'[group_id])
) + 0
Other visuals in the report which depend on the measures calculated using the data dimension table display correctly.
Is this an issue that can be caused by the measure? If so, can the above measure be created in a different, simpler way?
