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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Helper I
Helper I

Dax measure

Hi All,


Can anyone help for the dax measure for below excel function . we have  50+ merchants , example user has taken officeworks here, i need need to write dax which applies the 50+ merchants





Helper I
Helper I

Hi @TomMartens ,


i need to calculate Total remmitance based on the function provided in excel which is highlighted in screen shot


Total Remmitance = E15+F15+G15+H15+I15+J15-(E13+J13)


WE have all the columns we can add the totals , but my doubt is for E13+J13 user is picking the selected schema i,e officeworks giftcard and adding the E13 row and J13.. how to achieve this

Super User
Super User

Hey @Manjula ,


I have to admit that I do not understand your requirement.

In Power BI Desktop you can use the column merchant with a slicer visual, simply drag one of the numeric columns like GROSS SALES to a table visual and Power BI Desktop will automatically aggregate the values inside your table.


Hopefully, this provides some ideas on how to tackle your challenge.




Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.