cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brinky Helper II
Helper II

if is filtered

Hi All,

 

Im using this measure in a matrix with a month slicer, it works well when a month and months are selected, however when I select all  months no values will show.

 

IF(ISFILTERED(dDate[Month]),CALCULATE(SUM(data[Units]),dDate[Year]="2019"),BLANK())
 

Any idea how to fix?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: if is filtered

Hi @brinky ,

 

It is because when all the month are selected, the isfiltered(Month) will be false, if you want to show all the value when all month selected, we can use the following measure:

 

UnitsTotal =
    CALCULATE ( SUM ( data[Units] ), dDate[Year] = "2019" )

 


If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 


Best regards,


 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: if is filtered

Hi @brinky ,

 

It is because when all the month are selected, the isfiltered(Month) will be false, if you want to show all the value when all month selected, we can use the following measure:

 

UnitsTotal =
    CALCULATE ( SUM ( data[Units] ), dDate[Year] = "2019" )

 


If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

 


Best regards,


 

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors