Forum Discussion

Agent47's avatar
Agent47
Helper I
1 year ago
Solved

Total not adding up

As you can see , the total is not adding up. This is the model view  Measure_RA_SUM = CALCULATE( DISTINCTCOUNT('Risk Assesment'[Ra_Code]), TREATAS(VALUES('Hazard'[Risk]), 'Haza...
Need Help
Tips and Tricks
Tutorial Requests
  • danextian's avatar
    danextian
    1 year ago

    Hi Agent47 

     

    DISTINCTCOUNT is the hint. An Ra_Code could have more than one distinct risk values. At Risk level, there are 4, 49, 52, 4 and 21 distinct Ra_Code for each distinct Risk value. However, at Vessel_name level there are only 63 and not the sum of the indivdual breakdown

    In the screenshot below, you can see there are only 3 distinct codes so these will be count for Level2

     

     

    If you want your measure to evaluated for each distinct column values in your viz, use SUMX over a virtual/temporary table. Example:

    SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( 'data', 'data'[type], 'data'[name], 'data'[risk] ),
        "@value", [Measure_RA_SUM]
    ),
    [@value]
)

     

danextian's avatar
danextian
Super User
1 year ago

Hi Agent47 

 

DISTINCTCOUNT is the hint. An Ra_Code could have more than one distinct risk values. At Risk level, there are 4, 49, 52, 4 and 21 distinct Ra_Code for each distinct Risk value. However, at Vessel_name level there are only 63 and not the sum of the indivdual breakdown

In the screenshot below, you can see there are only 3 distinct codes so these will be count for Level2

 

 

If you want your measure to evaluated for each distinct column values in your viz, use SUMX over a virtual/temporary table. Example:

SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( 'data', 'data'[type], 'data'[name], 'data'[risk] ),
        "@value", [Measure_RA_SUM]
    ),
    [@value]
)