Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 🙂
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.