Total Customer Sales

Anonymous · ‎11-05-2020

Good

What measure you could use to know a customer's specific sales.

Could you also know the total sales of two specific customers?

For the calculation of the billing total the formula I use is:

Total Billing - SUMX(FactVentas,FactVentas[Tax Base]) + SUMX(FactVentas,FactVentas[VAT])

Say I have a DimClient, with its corresponding Key.

Thank you and a greeting.

amitchandak · ‎11-05-2020

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

Anonymous · ‎11-05-2020

@amitchandak

Is this good for you?

https://gyazo.com/f0fa535c5724e861bf52ad6ffff84d24

https://gyazo.com/72f835873e9c7fbf3220878d56513c6f

v-shex-msft · ‎11-08-2020

HI @Anonymous,

I'd like to suggest you share your sample file to onedrive for business or direct paste the dummy data table into your post as table format, then we can get them and test to coding formula.

How to Get Your Question Answered Quickly
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

vanessafvg · ‎11-05-2020

Hi

can you please share some sample data. Then can you provide an example of how you are wanting to view this.

If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!