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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
luisajara10
Frequent Visitor

hasonefilter power bi

Good day,

I am using the following formula:

measureName = IF(HASONEFILTER('TableA'[Date].[Year]),SUM('TableA'[numbers]),BLANK())

This measure brings information if the year is pressed, I need help with the following:
If the data segmentation of the year is pressed, it does not show any results and if it is pressed, only the month does not show any results, it should only show information if the year and month are pressed at the same time.

thank you.

2 ACCEPTED SOLUTIONS

Hello, thanks for answering.

I solved it in the following way.

I added the following to the function: &&HASONEFILTER(Calendar[Date].[Month])

It remained like this:

IF(HASONEFILTER('TableA'[Date].[Year])&& (HASONEFILTER('TableA'[Date].[Month]),SUM('TableA'[numbers]),BLANK())

I force the year and month segmentation buttons to be selected, if one is not selected, it does not show information.

View solution in original post

Hello, thanks for replying.

Fix it as follows.

add the following to the function: &&HASONEFILTER(Calendar[Date].[ Month])

It looks like this:

IF(HASONEFILTER('Table'[date].[ Year])&& (HASONEFILTER('Tablea'[date].[ Month]),SUM('TableA'[numbers]),BLANK())

I force that the year and month segmentation buttons are selected, if any is not selected it does not show information.

View solution in original post

5 REPLIES 5
Syndicate_Admin
Administrator
Administrator

Nice day

I am using the following formula:

nameMeasure = IF(HASONEFILTER('TableA'[Date].[ Year]),SUM('TableA'[numbers]),BLANK())

This measure brings information if the year is pressed, I need help with the following:
if the year slicer is pressed does not show any results and if it is pressed only month does not show any results, it should only show information if it is pressed year and month at the same time.

Thanks a lot.

@Syndicate_Admin , better you create a new column year column and use that

 

Year = Year([Date])

 

 

then

nameMeasure = IF(HASONEFILTER('TableA'[ Year]),SUM('TableA'[numbers]),BLANK())

 

also refer

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hello, thanks for replying.

Fix it as follows.

add the following to the function: &&HASONEFILTER(Calendar[Date].[ Month])

It looks like this:

IF(HASONEFILTER('Table'[date].[ Year])&& (HASONEFILTER('Tablea'[date].[ Month]),SUM('TableA'[numbers]),BLANK())

I force that the year and month segmentation buttons are selected, if any is not selected it does not show information.

amitchandak
Super User
Super User

@luisajara10 ,

better you create a new column year column and use that

 

Year = Year([Date])

 

 

then

measureName = IF(HASONEFILTER('TableA'[Year]),SUM('TableA'[numbers]),BLANK())

 

refer

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hello, thanks for answering.

I solved it in the following way.

I added the following to the function: &&HASONEFILTER(Calendar[Date].[Month])

It remained like this:

IF(HASONEFILTER('TableA'[Date].[Year])&& (HASONEFILTER('TableA'[Date].[Month]),SUM('TableA'[numbers]),BLANK())

I force the year and month segmentation buttons to be selected, if one is not selected, it does not show information.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!