Forum Discussion

Deemo's avatar
Deemo
Advocate II
6 years ago
Solved

Ignore selected columns and filter while calculating measures

Hi All,   Scenario is that we have to display those flows which are being used in more than one department based on selected date filter and department.   Below is the sample data(department ,flo...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Deemo ,

     

    Please create a measure and apply it in visual level filter.

    Measure 3 =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Department] ),
    ALLSELECTED ( 'Table'[Date], 'Table'[Department] ),
    REMOVEFILTERS ( 'Table'[Department] )
)

    .PBIX file

     

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Deemo ,

 

Please create a measure and apply it in visual level filter.

Measure 3 =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Department] ),
    ALLSELECTED ( 'Table'[Date], 'Table'[Department] ),
    REMOVEFILTERS ( 'Table'[Department] )
)

.PBIX file

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Deemo's avatar
Deemo
Advocate II
6 years ago

Thanks Liang.

I am getting error for REMOVEFILTERS (Cannot find name) and second part of ALLSELECTED (Unexpected parameter)

ALLSELECTED ( 'Table'[Date], 'Table'[Department] ),
    REMOVEFILTERS ( 'Table'[Department] )

I am connected to SSAS.