The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello All,
Im having a bit of a problem. Im am switching dimension dynamically using "TREATAS" as below screenshot. Everything is working great except in the case where im using a variable within the switch statement. In GPG case total value is correct but dimansions are coming repeated with same value. Do you know what is going on ?
Thank you And kind reagrds to all.
Solved! Go to Solution.
Hi @Anonymous ,
Without any data is difficult to give you the exact answers however, there is one thing that I can tell you that the calculation of variables is done one time and then reused on your code, taking into attention that you are using the var measure_type in the beginning this values is calculated once and then reused.
Try to place the measure_type inside the OPER variable the syntax is the same so you can make a var within a var.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Anonymous ,
Without any data is difficult to give you the exact answers however, there is one thing that I can tell you that the calculation of variables is done one time and then reused on your code, taking into attention that you are using the var measure_type in the beginning this values is calculated once and then reused.
Try to place the measure_type inside the OPER variable the syntax is the same so you can make a var within a var.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |