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 

You can upload it to OneDrive and post the link here.

or send link just by private letter.

Do mask sensitive data before uploading.

 

Best Regards,

Lin