Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
As you can see , the total is not adding up.
This is the model view
Risk is created from MAx_Risk_Rating
where there are multiple contradicting data but it is worked upon by custom SQL query which created HAZARD
Solved! Go to Solution.
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]
)
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]
)