Forum Discussion
Advocate ISum Total measure
Hi,
I have 2 tables with a differents measures calculated.
What I need to get is the total sum of the measure Vo.
This is because instead of just summing up the total, powerbi instead applies the same measure on the totals line.
Is there a way to calculating the sum? Is there a way to sum it using another measure somehow?
Thank you for your help!
Hi Med_Sami,
You can replace pv as vo in my previous measure, the new measure looks like below:
Measure = var t=SUMMARIZE('Table3','Table3'[pc],"vo",[vo])
return
IF(ISFILTERED([pc])=FALSE(),SUMX(t,[vo]),<DAX of measure vo>)Please replace the <DAX of measure vo> section as real DAX of measure vo.
Best Regards,
Qiuyun Yu
4 Replies
v-qiuyu-msftCommunity Support
Hi Med_Sami,
You can create a new measure below:
Measure = var t=SUMMARIZE('Table3','Table3'[pc],"pv",[pv])
return
IF(ISFILTERED([pc])=FALSE(),SUMX(t,[pv]),DIVIDE(CALCULATE(SUM(Table3[S]))*1000,CALCULATE(SUM('Table3'[Q])),"")))Best Regards,
Qiuyun Yu
Med_SamiHi, v-qiuyu-msft
Thank you for your help, the measure you wrote can help me to calculate the total sum of PV is interresting thank you, but what I'm looking for is the total sum of the measure VO.
Best Regards,
Med Sami- v-qiuyu-msft
Hi Med_Sami,
You can replace pv as vo in my previous measure, the new measure looks like below:
Measure = var t=SUMMARIZE('Table3','Table3'[pc],"vo",[vo])
return
IF(ISFILTERED([pc])=FALSE(),SUMX(t,[vo]),<DAX of measure vo>)Please replace the <DAX of measure vo> section as real DAX of measure vo.
Best Regards,
Qiuyun Yu
- Med_Sami