Forum Discussion

NvdVeerdonk's avatar
NvdVeerdonk
Frequent Visitor
7 years ago
Solved

Visual problem by showing total

I have a problem.   I made a visual in that visual are 2 colomns named Tarief and Totaal van Categerie.  No is my problem that i want to show the totals of those two after they multiplied with for...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, NvdVeerdonk 

    For your case, try this formula

    Measure = CALCULATE(SUMX('Tarieven 02','Tarieven 02'[Tarief]*CALCULATE(COUNTA('20190508 0916 export'[Categorie]))))

    Result:

     

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, NvdVeerdonk 

For your case, try this formula

Measure = CALCULATE(SUMX('Tarieven 02','Tarieven 02'[Tarief]*CALCULATE(COUNTA('20190508 0916 export'[Categorie]))))

Result:

 

 

Best Regards,

Lin