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'm a newbie at DAX...
So far I've managed my reports in Power BI with exel and vlookup calculations only... but they're exonerating!!
I would like to go one step beyond writing my formulas not in excel but directly in BI.
I have a series of stores with their own reference clusters and I calculate sales average per Cluster (I managed it with a quick measure) Now I should divide the sales of the room by its average...
I tried Calculate but I don't have to apply a single filter I need all the clusters.
Thanks !!
Hi thanks for the answer...
I will try to explain better. I ha ve two tabs
tab 1
Id Code | Cluster | Value |
1 | A | 4 |
2 | B | 20 |
3 | D | 10 |
4 | C | 8 |
5 | A | 9 |
6 | A | 15 |
7 | C | 7 |
8 | B | 2 |
and I computed in tab 2 the aggragate average for custer ( as pivot excel with field average).
Now I would obtaina in tab 2 le value ove cluster and than divide the value for its average, in this way
Id Code | Cluster | value | Average | Norm |
1 | A | 4 | 9 | 0,4 |
2 | B | 20 | 21 | 1,0 |
3 | D | 10 | 10 | 1,0 |
4 | C | 8 | 8 | 1,1 |
5 | A | 9 | 9 | 1,0 |
6 | A | 15 | 9 | 1,6 |
7 | C | 7 | 8 | 0,9 |
8 | B | 22 | 21 | 1,0 |
How I can implement in DAX?
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |