cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wongchungjec Frequent Visitor
Frequent Visitor

Ignore slicer in measure

Hi all,

 

I'd like to create the following scenario:

 

These are the correct values, but I want to filter the list with records wich only meet the criteria of 'MomenteelLeeg'

2019-03-01_15-21-57.png

 

I have tried it whith


CALCULATE(
COUNT(fct_Leeg[_Id]);
ALL(fct_Leeg[MomenteelLeeg])
)

 

But this returns the results below...(shows only last day)

2019-03-01_15-20-39.png

 

Any suggestions?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Ignore slicer in measure

@wongchungjec ,

 

You can 'ALL' table instead of 'ALL' a column like pattern below:

Result =
CALCULATE ( COUNT ( fct_Leeg[_Id] ); ALL ( fct_Leeg ) )

Community Support Team _ Jimmy Tao

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

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Ignore slicer in measure

@wongchungjec ,

 

If [MomenteelLeeg] is in a slicer, you may modify your measure like pattern below and check if the issue persists:

Result =
CALCULATE ( COUNT ( fct_Leeg[_Id] ); ALLSELECTED ( fct_Leeg[MomenteelLeeg] ) )

Community Support Team _ Jimmy Tao

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

wongchungjec Frequent Visitor
Frequent Visitor

Re: Ignore slicer in measure

Alas,

 

It still doesn't work..

Community Support Team
Community Support Team

Re: Ignore slicer in measure

@wongchungjec ,

 

You can 'ALL' table instead of 'ALL' a column like pattern below:

Result =
CALCULATE ( COUNT ( fct_Leeg[_Id] ); ALL ( fct_Leeg ) )

Community Support Team _ Jimmy Tao

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

 

Community Support Team
Community Support Team

Re: Ignore slicer in measure

@wongchungjec ,

 

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

 

Regards,

Jimmy Tao