Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I expanded rows in table to allow CSVs their own iterative rows. Unfortunately, one of the unique column values is now duplicated. All I need is that single value in a table visualization, but instead it tries summing it, or summing all the values.
While I understand the principle of row context, I still struggle how to actually work with it. I need to gain the unique value from the expanded rows, either to merely to display or to calculate with. Also, expanded rows often trip me up because I don't know how to handle them very well.
Quote Ct = CALCULATE( MAXX( 'Distinct Titles' , 'Distinct Titles'[Quote Count] ) / DISTINCTCOUNT( 'Distinct Titles'[Distinct Title] ) )
QUERY::
FRUIT QTY Type
Apple 15 01
Apple 07 01
Apple 09 01
Grape 10 03
Grape 05 03
VISUALIZATION: (Not wanted)
FRUIT QTY Type
Apple 31 03 (Sums)
Grape 15 06
VISUALIZATION: (Intended)
FRUIT QTY Type
Apple 31 01
Grape 15 03
I appreciate any help!
Solved! Go to Solution.
I realized I asked the question the wrong way and found a workaround. I can't delete this thread, which is why I'm marking this as "the answer" so the thread will close. Thanks for your time.
I realized I asked the question the wrong way and found a workaround. I can't delete this thread, which is why I'm marking this as "the answer" so the thread will close. Thanks for your time.
Hi @naridox ,
if the TYPE column does not need to be aggregated, change the data type to text so it won't add up.
Hi,
To your visual, drag Fruit and write these measures:
Quantity = SUM(Data[Qty])
Types = MIN(Data[Type])
My assumption is that Type is a numeric column.
@naridox ,
Type is not a number to be added or subtracted, correct? Mke Type a Text column. I do that with all my ids etc.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |