Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I want to create dax measure for below scenario. Can some please help
Table1:
Id | Type | Offer | Value |
1 | R1 | A | 100 |
1 | R1 | C | 100 |
1 | R2 | C | 100 |
1 | R2 | A | 100 |
Table2:
Id | Name |
1 | PBI |
Table1 & Table2 are related based on Id.
Expected Results : For selected Column, I should perform group by operation and get First Value for that group
Expected Result1:
Name | Value |
PBI | 100 |
Expected Result2:
Type | Name | Value |
R1 | PBI | 100 |
R2 | PB1 | 100 |
Thanks,
Abhiram
Solved! Go to Solution.
@abhiram342 , Hope both tables are joined on ID
Use a measure like this for value
Measure =
VAR __id = MAX ('Table'[ID] )
VAR __date = CALCULATE ( Min('Table'[Offer] ), ALLSELECTED ('Table' ), 'Table'[ID] = __id )
return
CALCULATE ( sum ('Table'[Value] ), VALUES ('Table'[ID] ),'Table'[ID] = __id,'Table'[Offer] = __date )
All columns are from table1 here . Use ID from Table 1 in visual
@abhiram342 , refer if the attached file can help
@abhiram342 , Hope both tables are joined on ID
Use a measure like this for value
Measure =
VAR __id = MAX ('Table'[ID] )
VAR __date = CALCULATE ( Min('Table'[Offer] ), ALLSELECTED ('Table' ), 'Table'[ID] = __id )
return
CALCULATE ( sum ('Table'[Value] ), VALUES ('Table'[ID] ),'Table'[ID] = __id,'Table'[Offer] = __date )
All columns are from table1 here . Use ID from Table 1 in visual
Thanks @amitchandak For each Id the value is same. Intially, I have designed model as below and was doing max for each selected column but it didn't worked.
Example: For Offer A, I should get 300 . Please let me know If I need to update the measure
Table2:
Id | Value |
1 | 100 |
2 | 200 |
Table1:
Id | Type | Offer |
1 | R1 | A |
1 | R1 | C |
1 | R2 | C |
1 | R2 | A |
2 | R3 | A |
@abhiram342 , refer if the attached file can help
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |