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.

Deemo's avatar
Deemo
Advocate II
6 years ago

Thanks for the reply Liang.Added sample data. Please check.

I actually want to calculate count (distinct department) group by flow and date(as per the date selected in filter). We need to display only those flow which are being used more than once in different account.

 

 

 

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.