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

Secondary Filter IF statement

Hi All

 

I have a simple IF statement that works to display an image URL when conditions are met, but I'd like it to evaluate only in the context of THIS calendar month. At the moment it either rolls up the result for all months in my table or I can get it to display direcrly in a table with each month represented.

It will let me have a second filter but it's not working.

Any ideas?

Up or Down Red = IF([Difference red]=0, PWAURL & "/_layouts/15/inc/PWA/images/cf_50p.png", PWAURL & "/_layouts/15/inc/PWA/images/cf_42p.png")

*Difference Red is just count of current - count of previous month data

Thanks
Faye
2 REPLIES 2
Community Support Team
Community Support Team

Re: Secondary Filter IF statement

Hi @Faye1901,

 

Here I made a test by creating a caluclate column.

 

Column = IF(Table2[Difference red]=0,MAX(Table1[Column1]),MIN(Table1[Column1]))

Then change the column to Web URL.

 

Capture.PNG2.PNG

 

Regards,

Frank

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

Re: Secondary Filter IF statement

Thanks for this. I've realised that a calculated column is the answer for sure - so I'm back to the drawing board. 

I've now: 
1. Created a summary table (so I don't need all those measures) using: 

Snapshot Summary =
SUMMARIZE (
ProjectSnapshots,
ProjectSnapshots[OverallStatus],
ProjectSnapshots[Created]
,"Count of Statuses", COUNT( ProjectSnapshots[OverallStatus] ))

2. Trying to create a measure for the previous month without success, at the moment I have: 
Previous Count = sumx(filter(all('Snapshot Summary'), [Created].[MonthNo]=EARLIER('Snapshot Summary'[Created].[MonthNo])-1), 'Snapshot Summary'[Count of Statuses])
 But I'm getting the incorrect result. See below. 

summary table BI.PNG
3. Once I've got that going then I can write the IF statement and it should work Smiley Happy 

Any thoughts! Feels like I'm close to a solution but not quite!

 



Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 338 members 4,090 guests
Please welcome our newest community members: