Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
find top month based on count of other value ..
Eg:august has 5k records sept has 10k records..
How to show sept in card visual !!??
Solved! Go to Solution.
Hi @Gokul,
Please share a dummy sample. You also can modify the measure below to achieve your goal.
top1 = MAXX ( TOPN ( 1, SUMMARIZE ( 'FactSales', DimDate[YearMonth], "AmountOfRecords", COUNTROWS ( FactSales ) ), [AmountOfRecords], DESC ), [YearMonth] )
Best Regards,
Dale
Hi @Gokul,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
using direct topn under visual card is also the best way...think so!!
Hi @Gokul,
Please share a dummy sample. You also can modify the measure below to achieve your goal.
top1 = MAXX ( TOPN ( 1, SUMMARIZE ( 'FactSales', DimDate[YearMonth], "AmountOfRecords", COUNTROWS ( FactSales ) ), [AmountOfRecords], DESC ), [YearMonth] )
Best Regards,
Dale
@Gokul - please post sample data
Did I answer your question correctly? Mark my answer as a solution!
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |