Forum Discussion
Ignore Filter in slicer
Yes that is what i expected, as I mentioned earlier, you need to use aggregated method like sum
TotalWithNewTable= IF(SELECTEDVALUE(NewTable[Column1])="USD", SUM(Table1[USDAmount]), SUM(Table1[EURAmount]) )
and add it as a measure.
YAY, glad to hear :)
Hey parry2k, I am facing a similar issue and already using the solution similar to one suggested by you.
I have a separate currency table, with values as EUR, USD and SWE, this I use as a slicer.
I have a measure:
Total Sales (selected currency) =
SWITCH(TRUE(),
[Selected currency]="EUR", FORMAT([Total sales (sek)]*VALUES('Currency'[Currency Rate]),"€0,00"),
[Selected currency]="USD", FORMAT([Total sales (sek)]*VALUES('Currency'[Currency Rate]),"$0,00"),
FORMAT([Total sales (sek)],"0,00kr"))
This Works fine individually or in a card visual or pretty much anywhere. The issue is, When I add this to my original Scenario i.e. A Table view from Orders and Products table with Additional slicers on Product Id(from Orders) and Product Name(From Products), The Slicers do not function visually.
i.e. I get the correct value for Selected Product ID and name, but
1. I get something like a combination table with Product name repeated for all Product ID.
2. The Measure column gives blank values for all other rows (which shouldn't be there in first place)
I am very new to DAX, so kindly bare with me if this is a very basic lack of understanding.
PS: This is the sample pbix file, I am using the Sample PBIX fro Curbal here. https://1drv.ms/u/s!As-Rm1c3rV4gu1rozmeWqkqGPC4e
Try to remove the format function from your Total Sales (selected currency) measure and then test.
Thanks parry2k, That works. Could you explain How/Why :)
I was assuming that it was the else condition which was causing issue.
And on a different/related note.. Could you suggest a way so that this works with Formatting.
Alternately I created a Measure which displays selected Currency in a column, There the issue is when user does not select any currency (hence would ned a default option).