Forum Discussion
Wrong total column
You need to use a SUMX calculation in order to get to the result you are looking for.
I have put a workbook togather with all the calculations you need: https://1drv.ms/u/s!AnKdZAdhTr78dKvMfL9WlrvogE8
OpenDataLab, thanks it worked. But, I though it would work for my real table. I purposely hid two others columns =(
Look, at my real data here.
I have two more columns, one named NATUREZA and other named EMISSAO. The EMISSAO column is a date and the NATUREZA column containg some text values.
On the example that gives 21.57 as a grand total, I have the following filters:
One page filter with NATUREZA ( look at the NATUREZA's values, I've edited it to be easy), just check the string values that contains USE_1, USE_2, USE_3 and USE_4 on the page filter.
And finally I created a slicer with the values of EMISSAO, the values are: Year = 2017, Month = 6 and Days = 1 to 19.
Can you help me to create the right measuere? I've already tried to use ALLEXCEPT, but it did not works....
Thanks.
Hi Anonymous,
So what columns do you want to show with the measures on the Table visual on the report, with NATUREZA and EMISSAO column or not? Could you post the expected result against your shared sample data? :smileyhappy:
Regards
v-ljerr-msft, currently I have this visual:
On the left side there is a EMISSAO slicer, the values should be between 01/06/2017 and 19/06/2017. And there is page filter using the NATUREZA column, its values that must be checked are USE_1, USE_2, USE_3, USE_4. The only thing that is different of what I want is the sum of MEDIA_PRAZO_MEDIO. The value that I want is 21.56, not 20.74.
