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.
I have a table that is created by the following DAX:
Not with a calculated table, you would have to use a pure measure to make it dynamic.
I use the previous slicer to show X salesperson on a table. If the user select 248 on slicer, the table will show 248 salesperson, if he choose 10 on slicer, the table will show 10 salesperson.
This values on slicer is a column from "Table" named Top that I mentioned before and this valeus is genereted by GENERATESERIES,
You tell me that I can't do this with calculated table, just pure measure, but how can I put a measure on a slicer to filter the table?
I create a calculated table because I just can filter with "real" values, in other words, I just can filter (put on slicer) values that came from table, not measure.
I think it is impossible achieve my goal, am I right?
Thanks for help Greg.
I use the previous slicer to show X salesperson on a table. If the user select 248 on slicer, the table will show 248 salesperson, if he choose 10 on slicer, the table will show 10 salesperson.
This values on slicer is a column from "Table" named Top that I mentioned before and this valeus is genereted by GENERATESERIES,
You tell me that I can't do this with calculated table, just pure measure, but how can I put a measure on a slicer to filter the table?
I create a calculated table because I just can filter with "real" values, in other words, I just can filter (put on slicer) values that came from table, not measure.
Could share some sample data and give expected result?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey @v-yuta-msft.
Yes, I can.
For example, I have the following table:
And I create a calculated table named "Top", like the following:
For example, I have the following visual:
My problem is: I have just 1 salesperson with sales on "October", if I select the Month October, I have the following result:
As you can see, the measure "DistinctCount of column Salesperson..." show me the value 1, and that is correct, I have only 1 salesperson with sales on October, but the "Count of Table "Top" and the Table "Top" continue showing 4, but I selected October, that correct value is 1.
The Table "Top" was created by this DAX: GENERATESERIES(1; DISTINCTCOUNT(Sales[Salesperson]); 1), like the measure "DistinctCount of column Salesperson..." but the calculated table doesn't suffer the action of filter like measure suffer.
Is it possible do something about dyamic calculated table, in other words, the table is calculated/created like a measure?
I use the column "Top" from table "Table" on a slicer.
Hello,
I have been struggling with the same problem for days. Is there any solution for this? BTW, I believe this might be solved by creating a relation between tables but I do not know how to create such a relation since I need to filter my range slicer by the date selection.
Cheers!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |