Forum Discussion
Divide Count
Hello, I have a simple problem that I want to do in Power BI.
The screenshot below shows a list of Shipments. I want to divide this column by the count of shipments greater than 1 and the count of total shipments.
Example
Divide 8 ( Count of numbers not 1) / 15 (Count of All numbers )
so i Get 0.53 as a result.
New Measure : =
DIVIDE (
CALCULATE ( COUNTROWS ( Data ), Data[Shipments] > 1 ),
CALCULATE ( COUNTROWS ( Data ), REMOVEFILTERS ( Data ) )
)
1 Reply
New Measure : =
DIVIDE (
CALCULATE ( COUNTROWS ( Data ), Data[Shipments] > 1 ),
CALCULATE ( COUNTROWS ( Data ), REMOVEFILTERS ( Data ) )
)