Forum Discussion
Conditional sum calculation based on two filters
Hi AllisonKennedy thanks for your explanation. This does help me understand how the formula works. Your formula works. but when I use the matrix visualization with Modality on Rows, TERMID on Columns, and FTE on Values I have the blank results as shown below. I do have the Term filter on this page.
What I want to achieve is some matrix table like this. 201508/201608... are the TERMIDs grouped under the column "Term" which includes Spring, Fall, Summer.
Can you please paste sample data table here or upload sample pbix file to onedrive so we can see what all your columns are with sample data so we know data types and constraints you need to work with?
You need to have only 1 value for Course Level as well, and I'm not sure that the TermID and Modality will provide this for you.
Thanks AllisonKennedy ! I followed your advice and put Course_Level on Rows, TERMID on Columns, FTE on Values. I am able to get a matrix visualization like this
What I want to do is a matrix visualization like the following: with Modality on Rows, TERMID on Columns, FTE on Values. I have Term, Campus, College etc. on the filters so the FTE changes dynamically when I click across different filters. How should I modify the formula?
Here is a screenshot of my dataset. Thank you!
Hi xliu1 ,
Create slicers for Term, Campus, College etc instead of using filters.
It's better to share you sample data as tables instead of pictures.
Best Regards,
Jay
Thanks for your suggestiom. I do not see an option to upload file here. And my work place does not allow file sharing using one drive or Dropbox etc. Are there any other options available for new members to share file? Thanks.