Forum Discussion
How to create Single Dax Measure for Max Values across Category (Multiple Dimension)
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% C...
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] )