Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I am trying to create a measure With calculate function which has a filter also. but when I applied that measure to the table it was not overriding the slicer.
TDP (test)* = var TDP_ITEM = CALCULATE(SUM(src_fact[WEIGHTED_DISTRIBUTION__W_]),FILTER(src_product,src_product[HIER_LEVEL_NAME] = "ITEM"))
Is there any way that I can get rid of this slicer on this DAX?
Solved! Go to Solution.
Hello
you can try using ALL() on the src_product table
Like this
TDP (test)* = var TDP_ITEM = CALCULATE(SUM(src_fact[WEIGHTED_DISTRIBUTION__W_]),FILTER(ALL(src_product),src_product[HIER_LEVEL_NAME] = "ITEM"))
Regards
Hello
you can try using ALL() on the src_product table
Like this
TDP (test)* = var TDP_ITEM = CALCULATE(SUM(src_fact[WEIGHTED_DISTRIBUTION__W_]),FILTER(ALL(src_product),src_product[HIER_LEVEL_NAME] = "ITEM"))
Regards
User | Count |
---|---|
12 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
19 | |
14 | |
8 | |
7 |