Forum Discussion
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.
Try to create measures like below:
Sum of count = SUM('Table'[Count])Percentage = DIVIDE( [Sum of count], CALCULATE(SUM('Table'[Count]),ALLSELECTED('Table')) )
2 Replies
V-lianl-msftCommunity Support
Try to create measures like below:
Sum of count = SUM('Table'[Count])Percentage = DIVIDE( [Sum of count], CALCULATE(SUM('Table'[Count]),ALLSELECTED('Table')) )- Greg_Deckler
Community Champion
jeje Basic syntax equivalent is SUMX(FILTER(...),...) or CALCULATE(SUM(...), FILTER(...))
