Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |