Visual problem by showing total

[NvdVeerdonk]

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 formule:

Tarief * Totaal van Categorie.  How can i do this. 

[v-lili6-msft]

hi, @NvdVeerdonk 

For your case, just create a calculate measure by this formula:

Measure = CALCULATE(SUM('Table'[Tarief]))*CALCULATE(SUM('Table'[Totaal van Categerie]))

https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-create-measures

https://docs.microsoft.com/en-us/power-bi/desktop-measures

By the way: If you want the total of the measure is 407+133650= 134057 not 148916

You could see this post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Then for your case, use this measure formula:

Measure 2 = 
VAR _table =
    SUMMARIZE (
        'Table',
        'Table'[Relatie],
        'Table'[Categorie],
        "_total", CALCULATE ( SUM ( 'Table'[Tarief] ) )
            * CALCULATE ( SUM ( 'Table'[Totaal van Categerie] ) )
    )
RETURN
    SUMX ( _table, [_total] )

here is pbix file, please try it.

Best Regards,

Lin

[NvdVeerdonk]

Dear Lin,

Thank you for the answer. I understand the measure only it gifs an error because "Totaal van Categorie" isn't a kolom in a table. This the valuwe Categorie. so i can't find Totaal van categorie and when i use Categorie i can't use the measure anywere. 

 

Best Regards,

Nicole

[v-lili6-msft]

hi, @NvdVeerdonk 

Which column are not numeric type?

Could you share your simple sample pbix file for us?

Best Regards,

Lin

[NvdVeerdonk]

 Hi @v-lili6-msft,

I'm just learning Power BI. 

How can i send you the sample?

i can share the data whit you but i need your E-mail ore you can requested an acces to the data: 

https://app.powerbi.com/groups/me/reports/1aab4f06-f191-4474-840c-047026adc3e6?ctid=09ac6aea-0dc4-42...

Let me know what i have to do.

Best Regards,

Van de Veerdonk

[v-lili6-msft]

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

[NvdVeerdonk]

 hi, @v-lili6-msft 

Here is de link from onedrive:

https://luxgroep-my.sharepoint.com/:u:/g/personal/nicole_vandeveerdonk_nobralux_nl/EZ3DMdHL3VtFoB9pL...

Best regards,

Van de Veerdonk

[v-lili6-msft · Accepted solution]

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