This is dynamic matrix in DAX.
VAR DefaultOfferValue =
SWITCH ( SelectedMeasureVal, "Home1, MAX ( value1 ), "Home2", MAX ( value2 ), "Home3", SUM ( value3 ), " Total99",
sumx (home1 +home2 +home3)....
return
DefaultOfferValue
The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
This is dynamic matrix in DAX.
VAR DefaultOfferValue =
SWITCH ( SelectedMeasureVal, "Home1, MAX ( value1 ), "Home2", MAX ( value2 ), "Home3", SUM ( value3 ), " Total99",
sumx (home1 +home2 +home3)....
return
DefaultOfferValue
@edhans Please see below current situation an excepted results:
This is dynamic matrix in DAX.
VAR DefaultOfferValue =
SWITCH (
SelectedMeasureVal,
"Home1, MAX ( value1 ),
"Home2", MAX ( value2 ),
"Home3", SUM ( value3 ),
" Total99",sumx (home1 +home2 +home3)....
return
DefaultOfferValue
Thanks a lot
@Xiaoxin Sheng I saw in several posting you have all experience in matrix. Could you please take look my issue thanks so much...
Use the filter pane. Let your measure calculate whatever is needed. Then:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reportingthanks @edhans for your help. But my problem also is that I need to sum "total column" that have the same name .
Then provide some data with expected results per links and instructions below. Please try to include ALL requirements in your post so we can attack all of the issues.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
36 | |
14 | |
12 | |
7 | |
7 |