Forum Discussion
Problem calculated coloum vs measure
I would like to get a matrix where I can see the regroupment by parity. as the first field the calculation of the calculated parity column and by drilling down display the details of the stores.
Marcox28,
Calculated column will not response to slicer selections, see https://community.powerbi.com/t5/Community-Knowledge-Base/Calculated-Column-Table-Change-Dynamically-According-to-Slicer/ta-p/163321.
In your scenario, to make Parita dynamically change according to date slicer, you would need to create a measure, however, measure can't be dragged into Rows of Matrix, thus it is not possible to create the Matrix as you describe.
A workaround is to create a summarized table containing Parita measure, and then create Matrix visual using this summarized table, but in this case, Parita measure will act as a static column in the summarized table and it can't be changed dynamically.
Regards,
Lydia
Hello,
It is incredible that PowerBI does not have a variable management such as qlik and tableau, I hope it will be implemented soon.
Yesterday I tried to study an alternative to get the matrix I need.
I feel that I am close to the solution but my knowledge does not help me.
I try to explain my reason:
I created a table with three columns, date column, shop column and parity column with two values a and c.
for each store I entered the values of the whole calendar with values c for every day that the store was closed while for all the remaining days.
here is the table.and these are the relationships
creating the matrix object I have only one problem:
when I select a given silgola everything works correctly, when instead selecting a range of data the stores are displayed both in group a and in group c.
is there a way to display it in group c if there is no value a and in group a if there is a value a?"is there a way to display it in group c if there is no value a and in group a if there is a value a?"
Could you please describe above requirement? Which table does the Ultime TNE_Descrizione field come from? What is your expected result based on the above sample data?
Regards,
Lydia