Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am still new at DAX and stumbling on this issue:
I need to create a table that shows the minimum value of a row per ID. The row value itself comes from a SQL.
This is what I wrote. In the column MININDEX for the given example, I should get a 1 everywhere. How do I correct the summarize command?
Thanks,
Pauline.
Hi @Berl21
Please try
Table Test Summarize =
SUMMARIZE (
'Partition_Rank_SQL',
'Partition_Rank_SQL'[DimOpportunityId],
'Partition_Rank_SQL'[ID_Row],
"MININDEX",
CALCULATE (
MIN ( 'Partition_Rank_SQL'[ID_Row] ),
ALL ( 'Partition_Rank_SQL'[ID_Row] )
)
)
Hi @tamerj1 I just replaced ALL by ALLSELECTED and it worked! Thanks a million 🙂
User | Count |
---|---|
20 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
29 | |
28 | |
12 | |
12 | |
12 |