Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Calculated % measure

Hello,    I have problems creating a measure, i want to show on a line chart the percentage of "orders on time" (1). My power bi table looks like the first one with orders and itmes, and when I ma...
Need Help
Show and Tell
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    Hi Anonymous

     

    You may create measure as below:

    Measure =
COUNTROWS ( SUMMARIZE ( FILTER ( Table1, Table1[Time] = 1 ), Table1[Order] ) )
    / DISTINCTCOUNT ( Table1[Order] )

     

    Regards,

    Cherie

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Anonymous

 

Try this one

 

Measure =
VAR orderswithTime1 =
    COUNTROWS (
        FILTER ( VALUES ( Table1[Order] ), CALCULATE ( SUM ( Table1[Time] ) ) > 0 )
    )
VAR TotalOrders =
    COUNTROWS ( VALUES ( Table1[Order] ) )
RETURN
    DIVIDE ( orderswithTime1, TotalOrders )