Impossible to determine a unique value for column X1 in table X

[alloja]

Hello,

Here is the capture. The message in yellow was displayed as indicated in the object. Is there a solution to this "problem"?

Please note that these are What-if parameters: [Tarif/CV <10ans] and [Tarif/CV >=10 ans].

Thanks for your help.

[Anonymous · Accepted solution]

Hi @alloja ,

I create a table and two measures as you mentioned.

Tarif/CV <10 ans = 
IF (
    MAX('Global'[barf.etat_vn_vo]) = "VO<10ans",
    100, 
    0
)

Tarif/CV>10 = 
IF (
    MAX('Global'[barf.etat_vn_vo]) = "VO>=10ans" || MAX('Global'[barf.etat_vn_vo])="VN",
    200, 
    0
)

Then I put the DAX code into a measure, it gives me the same error.

So I think you can use SUM function or Max function in matrix visual. If you use SWITCH function, it also can give you the correct result.

Measure = 
SUMX (
    'Global',
    SWITCH (
        TRUE (),
        'Global'[barf.etat_vn_vo] = "VO<10ans"
            && 'Global'[barf.montant_y1] > 0, 'Global'[barf.puiss_admin] * [Tarif/CV <10 ans],
        'Global'[barf.etat_vn_vo] = "VN"
            && 'Global'[barf.montant_y1] > 0, 'Global'[barf.puiss_admin] * [Tarif/CV <10 ans],
        'Global'[barf.etat_vn_vo] = "VO>=10ans"
            && 'Global'[barf.montant_y1] > 0, 'Global'[barf.puiss_admin] * [Tarif/CV>10],
        0
    )
)

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alloja]

Hello,

Thank you very much. I saw "SWITCH", but refrained from using it because I didn't understand its use.

Once again, thank you very much.

Best regards,

alloja

[mickey64]

For your reference.

[Ritaf1983]

Hi @alloja 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly