Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey All,
Looking to get a divide of the below data.
On the first metro line i need to get a new measure that would divide the metro that has a blank floor display entry against the on that has "floor display" next to it.
So 534 / 13 really. I have tried using a calculation and various bits to filter the data but cant get the answer im after.
The count of Customer Ref is a distict count as well.
Thanks,
Adam
Hi @amitchandak,
I get the following error -
Here is my measure.
Hi @Anonymous
Your measure will return error, if you use sum function to summarize the text type column "Customer Ref Copy".
You can try distinctcount function to caluclate the distinct count of Customer Ref Copy.
My measure:
Measure =
VAR _MetroFloorDisplay =
CALCULATE(
DISTINCTCOUNT('Sales Orders Items'[Customer Ref Copy]),
FILTER(ALL('Sales Orders Items'),MAX('Sales Orders Items'[Model])="Metro"&&'Sales Orders Items'[Floor Display] = "Floor Display"))
RETURN
IF(
MAX('Sales Orders Items'[Model])="Metro"
&&
ISBLANK(MAX('Sales Orders Items'[Floor Display])
),
DIVIDE(
DISTINCTCOUNT('Sales Orders Items'[Customer Ref Copy]),
_MetroFloorDisplay
)
)
Result is as below.
534/13 = 41.08
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This wasn't solved by that solution im afraid.
Unsure why it has been marked as solved?
@Anonymous , Please try a measure like
divide(calculate(sum(Table[Ref Copy]), filter(Table, isblank(Table[floor display]))),calculate(sum(Table[Ref Copy]), filter(Table, Table[floor display] ="floor display")))
Hi @amitchandak,
I get the following error -
Here is my measure.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |