Forum Discussion

jeje's avatar
jeje
New Member
4 years ago
Solved

Sumif

I'm trying to get the total number of status column ( complete, not complete, partial complete) and the values in column count, how do i place this in measure in PBI? Thanks for the help.  
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Try to create measures like below:

    Sum of count = SUM('Table'[Count])
    Percentage = 

DIVIDE(
        [Sum of count],
		CALCULATE(SUM('Table'[Count]),ALLSELECTED('Table'))
		
	)

     

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Try to create measures like below:

Sum of count = SUM('Table'[Count])
Percentage = 

DIVIDE(
        [Sum of count],
		CALCULATE(SUM('Table'[Count]),ALLSELECTED('Table'))
		
	)