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.
Can we have a dynamic 'maximum value' in a gauge based on Top 5/10/25/ALL selection ?
Here is the scenario
1. I have a table with the following columns.
2. I am calculating following two measures:
Shipment Count = DISTINCTCOUNT(tblImportMaster[BillLadingNo])
Sum of Weight = SUM(tblImportMaster[Weightkg])
Using these two measures I am calculating a third measure as follows:
Volume = [Shipment Count] * [Sum of Weight]
3. In this step, I am calculating RANK by Sellers w.r.t Volume
SellerRankByMeasure = RANKX(ALL(tblImportMaster[Shipper]),[Volume],,DESC)
4. Now, I have a slicer for Top 5/10/25/ALL. Using this custom slicer that is created, we are filtering the records by the following measure:
SellerRankVolume = IF([SellerRankByMeasure]<=[SelectedTopNValue],[Volume])
So if I plot the following visual in a table, it works fine. However if I want to change this volume dynamically based on the Top 5/10/25/ALL
slicer, it does not reflect the 'sliced' value in the GAUGE.
Can we have a value in the gauge (in the maximum section) to be filtered dynamically ?
Any help here would be appreciated. Thank you
Hi ketan10,
TopN is a calculate column and SelectedTopNValue is a measure, right?
If you are using single selection, you can refer to this pattern:
[SelectedTopNValue] =
SELECTEDVALUE ( Table[TopN] )
If you are using multiple selection, you can refer to this pattern:
[SelectedTopNValue] = CALCULATE ( SUM ( Table[TopN] ), ALLSELECTED ( Table[TopN] ) )
Hope it's helpful.
Regards,
Jimmy Tao
Hello,
do you know where the 2470 comes from?
What would be the expected result?
Does value change if you change your slicer?
Best regards.
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 |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |