Difference on sales between categories per day

[Miguelcrz]

Hi! I would like to get the difference that has a category vs the others in sales and transactions. The category i would like to evaluate is "Belleza Coreana" vs "Cuidado de la piel" and vs "Mascarillas". I am attaching a image with the graphic i would like to have to get the % of difference between one to other.

For example, on august 15 i had 105 transactions of belleza coreana, 421 of cuidado de la piel and 233 of mascarillas.

So belleza coreana is -73.82% lower than cuidado de la piel and -54.52% lower than mascarillas.

In sales should be the same: On August 15 i had sales of $ 3,697 in belleza Coreana, $ 17,003 in cuidado de la piel and $ 5,302 in mascarillas. So, belleza coreana is -78.26% lower than cuidado de la piel and -30.27% lower than mascarillas.

Hope u can help me. Thanks!!

[v-jayw-msft]

Hi @Miguelcrz ,

Check the measure and visual below If i misunderstand your meaning, please let me know.

% = (CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),'Table'[type]=SELECTEDVALUE('Type'[type])&&'Table'[date]=SELECTEDVALUE('Table'[date])))-SELECTEDVALUE('Table'[value]))/SELECTEDVALUE('Table'[value])

 

Best Regards,

Jay

[Greg_Deckler]

@Miguelcrz Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.