Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have created the following measures, but what I get is not what I am expecting. I can fix the problem but changing the all function for
Solved! Go to Solution.
Since you don't likely have a single row for each seller in that table, you will not get the expected behavior. I think you will need separate measures for your different scenarios (when different columns in the table), or have them all as variables and choose from them with ISINSCOPE, etc.. If you will have those 3 columns, you can use ALL( ) with all 3 in it.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Since you don't likely have a single row for each seller in that table, you will not get the expected behavior. I think you will need separate measures for your different scenarios (when different columns in the table), or have them all as variables and choose from them with ISINSCOPE, etc.. If you will have those 3 columns, you can use ALL( ) with all 3 in it.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I never heard of isinscope. Could you please write an example with column seller and store please
I don't recommend that approach. You would be writing mulitple variables each with a different RANKX expression. Writing a Rankx measure for each scenario is simpler.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |