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...
  • 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