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.
Ok,
I have table ATstreams where i want to divide a metric by the same metric except segmented on another column.
Simply in psuedocode its Streams where [pname] contains "Extras" / Streams
So step one i create a new column called [extra streams], thats fine
Now for the life of me I cant create a measure or column or whatever that does [extra streams]/[streams], i get all sorts of figures.
All of this is presented rolled up in a table of course.
I even tried this in one step to no avail:
%Extras =
CALCULATE(sum('ATStreams'[Streams]),
RIGHT('ATStreams'[PName], 6) = "Extras") / 'ATStreams'[Streams]
Solved! Go to Solution.
You may try the measure below.
Measure = CALCULATE ( SUM ( 'ATStreams'[Streams] ), RIGHT ( 'ATStreams'[PName], 6 ) = "Extras" ) / SUM ( 'ATStreams'[Streams] )
You may try the measure below.
Measure = CALCULATE ( SUM ( 'ATStreams'[Streams] ), RIGHT ( 'ATStreams'[PName], 6 ) = "Extras" ) / SUM ( 'ATStreams'[Streams] )
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |