Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 o...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    New Measure : =
    DIVIDE (
    CALCULATE ( COUNTROWS ( Data ), Data[Shipments] > 1 ),
    CALCULATE ( COUNTROWS ( Data ), REMOVEFILTERS ( Data ) )
    )

     

     

    Link to the sample pbix file 

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

 

New Measure : =
DIVIDE (
CALCULATE ( COUNTROWS ( Data ), Data[Shipments] > 1 ),
CALCULATE ( COUNTROWS ( Data ), REMOVEFILTERS ( Data ) )
)

 

 

Link to the sample pbix file