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 All,
I have a requirement where I have to display 3 cards Total Conversions, Site Conversions and Conv %(of Site).
The Conv%(of Site) is a DAX measure which is "TotalConversions/Sum(Site Conversions)".
The Site Conversion has been used Edit Interactions feature which will not be filtered with slicers Category and Mailing Name.
The Problem arises when I am selecting the slicer Mailing Name or Category the value Site Conversions is not changing as the its using Edit interactions feature, the %Conv=1/12,210=0.008% but its showing up 0.4% as shown below.
Please help me solve this Conv% DAX which should be calculated based on the Site conversions card display.
Thanks in Advance,
Neelofar Shama
Solved! Go to Solution.
Hi @neelofarshama ,
I have change the slicer for send date in SFMC_SENDS table to date in DAILY_SITE_CONVERSIONS, if you use send date it will be filter by the slicer mailing name even though you use the
.
Then you can use the following measure:
site conversions =
CALCULATE (
SUM ( DAILY_SITE_CONVERSIONS[CONVERSIONS] ),ALL(SFMC_SENDS[Category],SFMC_SENDS[Mailing Name]))
Please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @neelofarshama ,
You don't need to edit Interactions between site conversions card and slicers. Just use the all function in your card measure:
Site conversions = SUMX(ALL(Table),Table[Site conversions])
Then you can use the TotalConversions/Sum(Site Conversions) for Conv%
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi,
Thank you for the reply but I cannot use ALL() function as I have other columns in this table like "Property" and "Date" to filter the Site Conversion card as shown below.
All the slicers are in a different called Table3 but Site Conversion in in Table2.
@neelofarshama , try using all or remove filters
new %Con =
calculate([%Con], all(Table[Mailing Name]), all(Table[Category]))
or
new %Con =
calculate([%Con], removefilters(Table[Mailing Name],Table[Category]))
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak
Hi @amitchandak ,
I tried the DAX you have suggested is also not giving accurate results. Can you please suggest some alternative.
Hi @neelofarshama ,
Using something like below:
Conv%(of Site) = TotalConversions / CALCULATE(Sum(Site Conversions),REMOVRFILTERS(Table[Mailing Name],Table[Category]))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @v-deddai1-msft ,
I tried this but doesnt work for some reason I am not able to figure out.
Hi @neelofarshama ,
Would you please show me your sample pbix file? You must miss something to make the formula work.
Best Regards,
Dedmon Dai
Hi @neelofarshama ,
I have change the slicer for send date in SFMC_SENDS table to date in DAILY_SITE_CONVERSIONS, if you use send date it will be filter by the slicer mailing name even though you use the
.
Then you can use the following measure:
site conversions =
CALCULATE (
SUM ( DAILY_SITE_CONVERSIONS[CONVERSIONS] ),ALL(SFMC_SENDS[Category],SFMC_SENDS[Mailing Name]))
Please refer to the pbix file.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |