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.
Hi !
Refer Pic:-
File Link:- https://www.dropbox.com/s/gp3nc7o5cdi6bfy/eg.pbix?dl=0
I want to return the global category number OG wise, which I am getting correct in Table 1 and for Table 2 i want to filter the concatenated colum (OGXCategory) based on category Slicer selection and the number it should return is of respective OG that is present in Table 1 .
For e.g. in Table 2 for
APAC COLA I want to return 54,
EMEA COLA I want to return 65...
If i select RTD Tea then also for
APAC RTD Tea I want to return 54,
EMEA RTD Tea I want to return 65...
Thanks in advance !
Solved! Go to Solution.
Hello,
you'll need to restore the original filter context on the OG Short column. To do this, you can use the VALUES function. Also, you can include all the columns in the Same All function.
OGXCat Category Base =
CALCULATE(
SUM(Sheet3[CY])/100000,
ALL(Sheet3[Ctgry Nomen], Sheet3[New Category Defination], Sheet3[OGXCat]),
VALUES( Sheet3[OG Short] )
)
Hope this solve your issue
Hello,
you'll need to restore the original filter context on the OG Short column. To do this, you can use the VALUES function. Also, you can include all the columns in the Same All function.
OGXCat Category Base =
CALCULATE(
SUM(Sheet3[CY])/100000,
ALL(Sheet3[Ctgry Nomen], Sheet3[New Category Defination], Sheet3[OGXCat]),
VALUES( Sheet3[OG Short] )
)
Hope this solve your issue
@souvik900766 You are almost certainly missing a relationship between the table used for the slicer and your second table.
No I am not using any other table...it's a single table
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |