Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Joshua_
Helper I
Helper I

FILTER ALL?

Hi,

 

I have the following measure.

 

SIMR.png
 
The measure is correct, because I get all the sales (Coloc Productiva), but in my dashboard have filters externs, for example the months,type... and that when changing the filter, the measure does not change.
SIMR2.png
 
 
SIMR3.png
 
Would I have to add more filters in my measure? One for date, another for the type? 
 
 

SIMR4.png
 
 
Thank you very much.

Regards.


1 ACCEPTED SOLUTION
az38
Community Champion
Community Champion

Hi @Joshua_ 

its a correct behaviour because you are using ALL() function that clear all functions.

try 

=calculate(sum([_Saldo_Real_Mes_T_]), SIMR[GRUPO]="Coloc Productiva")

or change ALL() to ALLSELECTED or ALLEXCEPT. it depends on user behaviour in your report

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

2 REPLIES 2
az38
Community Champion
Community Champion

Hi @Joshua_ 

its a correct behaviour because you are using ALL() function that clear all functions.

try 

=calculate(sum([_Saldo_Real_Mes_T_]), SIMR[GRUPO]="Coloc Productiva")

or change ALL() to ALLSELECTED or ALLEXCEPT. it depends on user behaviour in your report

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors