'How to convert Tableau LOD to PowerBI DAX
I am trying convert tableau Fixed LOD expression to Power BI DAX seems not working as expected. Power BI ALLEXCEPT FUNCTION is accepting multiple values but result not as same as Tableau Fixed LOD. Need you help.
Tableau-LOD={FIXED[country],[year],[month]:AVG([Net Rev])}---pls help
Power BI = CALCULATE(AVERAGE(table[Net Rev]), ALLEXCEPT(table, table[country],table[year],table[month] ))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|