How to create Single Dax Measure for Max Values across Category (Multiple Dimension)

[HitendraD]

I have the following Data

Source Name	# Total Journals	% of Selected Journals	Max Value	% of Max
Payables	13,302	39.40%	13,302	100%
Spreadsheet	10,385	30.80%	13,302	78%
Cost Accounting	3,670	10.90%	13,302	28%
Receivables	3,022	9.00%	13,302	23%
Receipt Accounting	1,261	3.70%	13,302	9%
Projects	514	1.50%	13,302	4%
Assets	460	1.40%	13,302	3%
Manual	451	1.30%	13,302	3%
AutoCopy	302	0.90%	13,302	2%
Cash Management	150	0.40%	13,302	1%
Revaluation	117	0.30%	13,302	1%
Tax	87	0.30%	13,302	1%
Conversion	5	0.00%	13,302	0%

To calculate Max Value, following Dax function is used.

MAXX (

        CALCULATETABLE (

            VALUES ( 'Fact-Journals'[Source Name]),

            ALLSELECTED ( 'Fact-Journals'[Source Name] )

        ),

        [# Total Journals]

    )

 I need to use this function for multiple dimensions other than source, it is resulting in high maintainence of Dax.
Also majorly this function is used for conditional formatting.

Is there a way, where instead of VALUES ( 'Fact-Journals'[Source Name]), dax functions can dynamically select the dimensions in row context.

[Hema_Gupta]

Hi ,

Hope this helps

Max Value Across Categories =

VAR SummaryTable =

    SUMMARIZE (

        'Fact-Journls',

       'Fact-Journls'[Source Name],

        'Fact-Journals'[Dimension1],

         'Fact-Journals'[Dimension2],

          ... //  You can Add more dimensions as needed

        "MaxValue",

        CALCULATE ( MAX ( 'Fact-Journls'[#Total Journals] ) )

    )

RETURN

    SUMX ( SummaryTable, [MaxValue] )