Forum Discussion
Adding 2 rows in a dataset
My input dataset is as follows:
| Cash | 20
|
| CashX | 0.90 |
| Interest | 2.6 |
| Loan | 100 |
When I'm reporting on the above data, Cash column must be calculated as value(Cash+CashX).
I'm trying to use a measure to do this, but I cant add botht he numbers.
Any help is greatly appreciated.
ara
Anonymous , Create a new column
New group = switch( True(),[column] in {"Cash","CashX"},"Cash",
[column])
or try binning/
SEGMENTATION
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/Hi,
Write this calculated column formula and rename the column to Revised text
=if(ISNUMBER(SEARCH("Cash",Data[Text],1,BLANK())),"Cash",Data[Text])To your visual, drag this revised text column and write this meaure
Total = SUM(Data[Amount])Hope this helps.
7 Replies
Anonymous , Create a new column
New group = switch( True(),[column] in {"Cash","CashX"},"Cash",
[column])
or try binning/
SEGMENTATION
https://radacad.com/grouping-and-binning-step-towards-better-data-visualization
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/Thanks amitchandak
Using the switch statement, I now have 2 Cash rows, how do Iadd the values of Cash and CashX?
Hi,
Try this measure
=calculate(sum(data[amount]),data[text]="Cash"||data[text]="Cashx")
Hope this helps.
Hi Ashish_Mathur , every data row text gets the added value.
I do not understand your comment at all.