Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
14 | |
12 | |
12 | |
9 |
User | Count |
---|---|
63 | |
22 | |
21 | |
17 | |
11 |