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

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
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