On a matrix table, i am trying to add a calculation at the end, but that measure keeps getting added after every single column. Please advise on how to add that calculated value only once.
I wish to get the below.
The Shipped, Cancelled and complete are statuses from a single column. Now when i try to add a new measure (completed%), it shows up after every single column. Any advise please ?
Proud to be a Super User!
Create a measure like
or column like
The measure i have for the matrix is StatusCount = calculate(counta(Accounttable), userelationship (datetable(date), Accounttable(date))).
the only way to prevent that from happening is to create a measure for each status rather than slice by the status.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.