Forum Discussion

Saloni_Gupta's avatar
Saloni_Gupta
Icon for Helper I rankHelper I
2 years ago
Solved

How to compare the values in two Summarize tables

Hi All, I have a requirement to create histograms and this is the dax that I am using to create the x-axis in a table. var _t = SUMMARIZE( 'DimTable' ,'DimTable'[Client] , "sumvarianceclient" , ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Saloni_Gupta ,

     

    Try to modify your formula like below:

    result_ = 
VAR _max_value_t =
    MAXX ( _t, [ByClinet] )
VAR _max_value_p =
    MAXX ( _p, [ByProduct] )
VAR _max_value =
    MAX ( _max_value_t, _max_value_p )
VAR _min_value_t =
    MINX ( _t, [ByClinet] )
VAR _min_value_p =
    MINX ( _p, [ByProduct] )
VAR _min_value =
    MIN ( _min_value_t, _min_value_p )
RETURN
    GENERATESERIES ( _min_value, _max_value )

     

    Best Regards,
    Adamk Kong

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Saloni_Gupta ,

 

Try to modify your formula like below:

result_ = 
VAR _max_value_t =
    MAXX ( _t, [ByClinet] )
VAR _max_value_p =
    MAXX ( _p, [ByProduct] )
VAR _max_value =
    MAX ( _max_value_t, _max_value_p )
VAR _min_value_t =
    MINX ( _t, [ByClinet] )
VAR _min_value_p =
    MINX ( _p, [ByProduct] )
VAR _min_value =
    MIN ( _min_value_t, _min_value_p )
RETURN
    GENERATESERIES ( _min_value, _max_value )

 

Best Regards,
Adamk Kong

 

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