Forum Discussion

C4YNelis's avatar
C4YNelis
Advocate III
9 years ago

Calculated column does not work?

Dear all,   I am currently trying to create a solution where I can dynamically fill one and the same matrix, based on several columns with criteria. All my columns (which all have a (text) value si...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi C4YNelis,

>>Finally (and this is where things go wrong), I want to fill the calculated column.
Where did you create the calculated column? In your scenario, there are several tables. From the screenshot, I am not reproduce the same scenario.

Based on my understanding, I try to create sample data shown in the screenshot below and test it as follows.


First I create a slicer including the Bom scenario’s field. Create a measure like yours, create a card used to display the result.

gefilterd scenario = If(CountRows(Test4)=1,VALUES(Test4[Bom scenario's]),Blank())




Finally, create a calculated using the following formula and get the desired result.

 

result = IF(Test4[Bom scenario's]="Order>90dgn",TRUE(),FALSE())




In addition, if you have multiple values in the field used in slicer like the first screenshot. Then it will return blank even though I use the same measure. Because the CountRows(Table13) is not 1. So it return the wrong result.

 

gefilterd scenario111 = If(CountRows(Table13)=1,VALUES(Table13[Bom scenario's]),Blank())


 

If this is not what you want, could you please post the .PBIX for better analysis?

Best Regards,
Angelia