Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'd like to calculate Total of Category1 / Total of Total (e.g 1.570.673/4.272.815).
I tried
Distrubition = DIVIDE(Listing[Total];[Total(Stock_Amount)])
but it shows %100 for all rows. Also I tried to get percentage of each columns Total (e.g 16.500/4.272.815) but couldn't find the answer too.
kind regards
-- First of all, [Total] must be the main measure. -- Then, Distribution can be calculated as: [Distribution] = -- Category must be the one that you put -- on the visual to break down calculations -- by. var __visibleCategories = ALLSELECTED( T[Category] ) var __totalAcrossVisibleCategories = CALCULATE( [Total], __visibleCategories ) var __totalForThisCategory = [Total] var __distribution = DIVIDE( __totalForThisCategory, __totalAcrossVisibleCategories ) return __distribution -- WARNING: -- Do not ever use this measure in model -- measures that iterate over a table. If -- you do, you'll be sorry rather sooner -- than later. This measure is safe only -- when used in visuals.
Best
Darek
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |