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
DHEG97
Frequent Visitor

Switch 2 Filter to show the opposite result

Hello,
I have 2 Filters selected From and To
(e.g. From (Germany) and To (France) )

FROM               TO              Volume FROM-TO              Volume TO-FROM

DE                     FR               2000


This shows me the volume we generated for this relation in a separate column
now I want to show the volume if the flow will go reversed (without changing the filters)

(This is how its been displayed right now for the "Volume From" column)

Volume FROM-TO =
VAR FromC =
FILTER('Table', 'Table'[FromCountry]=SELECTEDVALUE('Table'[FromCountry]))
RETURN
CALCULATE(SUM('Table'[Volume]),FromC)


Now I need a similar measure to dispay into the opposite direction for the"Volume to" column

Any ideas how to display this?

2 REPLIES 2
amitchandak
Super User
Super User

@DHEG97 ,

 

Volume FROM-TO =
VAR FromC =
FILTER('Table', 'Table'[toCountry]=SELECTEDVALUE('Table'[ToCountry]))
RETURN
CALCULATE(SUM('Table'[Volume]),FromC)

 

or

 

Volume FROM-TO =
VAR FromC =
FILTER('Table', 'Table'[FromCountry]=SELECTEDVALUE('Table'[ToCountry]) && 'Table'[FromCountry]=SELECTEDVALUE('Table'[FromCountry]))
RETURN
CALCULATE(SUM('Table'[Volume]),FromC)

 @amitchandak The first option will show me the volume from-to aswell in the new column
and the second option shows only blank entries

Where can I attach sample Data?

"The file type (.pbit) is not supported."

Drag and drop doesnt work in this case
 

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.