Skip to main content
cancel
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

Reply
Manjula
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

Manjula_0-1656927043797.png

 

Regards,

Manjula

2 REPLIES 2
Manjula
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

TomMartens
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.

 

Regards,

Tom



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

Announcements
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.