Forum Discussion

gunter_gysegom's avatar
gunter_gysegom
Regular Visitor
6 years ago
Solved

Retrieve value from a column filterd on a 2ndcolumn form the sale table

  I have a report containing 3 tables   Table 1 Data Table 2 Customer Data Table 3 Dimension Data   The 3 tables containes the customer no. as a common field Table 1 is connected to table 2...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi gunter_gysegom ,

     

    Withouth making any test on your tables and calculation I have checked the problem with your code (1st issue you present) can you please try this formula:

     

    CALCULATE (
    FIRSTNONBLANK ( 'Distrac NVDefault Dimension'[Dimension Value Code]; 1 );
    FILTER (
        ALL ( 'Distrac NVDefault Dimension' );
        'Distrac NVDefault Dimension'[No_] = 'Distrac NV Customer'[No_]
            && 'Distrac NVDefault Dimension'[Dimension Code] = "KLANTGROEP"
    )
)

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi gunter_gysegom ,

 

Withouth making any test on your tables and calculation I have checked the problem with your code (1st issue you present) can you please try this formula:

 

CALCULATE (
    FIRSTNONBLANK ( 'Distrac NVDefault Dimension'[Dimension Value Code]; 1 );
    FILTER (
        ALL ( 'Distrac NVDefault Dimension' );
        'Distrac NVDefault Dimension'[No_] = 'Distrac NV Customer'[No_]
            && 'Distrac NVDefault Dimension'[Dimension Code] = "KLANTGROEP"
    )
)

 

 

gunter_gysegom's avatar
gunter_gysegom
Regular Visitor
6 years ago

hi MFelix 

 

It work thanks for the help