Forum Discussion

SteveODea's avatar
SteveODea
Icon for Helper I rankHelper I
2 years ago
Solved

Get Visualisation to Ignore a Filter

I have a Power BI Report which has a number of Filters, including one for 'AppCycleYear'. On one page. I am trying to create a Table visualisation which shows the CountOfApplications by AppCycleYear ...
  • SteveODea's avatar
    SteveODea
    2 years ago

    I managed to solve this myself by creating a second Calendar table and setting up an inactive relationship between my main table and and the second calendar table.

     

    I then created a measure which relates my applications table to the new calendar table using USERELATIONSHIP and which ignores the original Calendar table using ALL as follows

     

    Count_Applications = 
    CALCULATE( 
    DISTINCTCOUNT(applications[application_id])],
     USERELATIONSHIP(applications[CompletedDate],'Calendar2'[Date]),
                    ALL('Calendar'[AppCycleYear])
        )
     
    Bit clunky, but it works
SteveODea's avatar
SteveODea
Icon for Helper I rankHelper I
2 years ago

I managed to solve this myself by creating a second Calendar table and setting up an inactive relationship between my main table and and the second calendar table.

 

I then created a measure which relates my applications table to the new calendar table using USERELATIONSHIP and which ignores the original Calendar table using ALL as follows

 

Count_Applications = 
CALCULATE( 
DISTINCTCOUNT(applications[application_id])],
 USERELATIONSHIP(applications[CompletedDate],'Calendar2'[Date]),
                ALL('Calendar'[AppCycleYear])
    )
 
Bit clunky, but it works