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
Community Support
7 years ago

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's avatar
    NvdVeerdonk
    Frequent Visitor
    7 years ago

    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