topic any way to change Type depending on condition in DAX Commands and Tips

any way to change Type depending on condition

Anonymous — Wed, 27 Jul 2022 07:01:13 GMT

Hi,

Attached is a simple test spreadsheet. One of columns is called "Type" which consists of Wastage, Quarantine and Rework.

On some occasions, although type is selected as Wastage, it occurs hours to spend for rework.

Since I need to populate data under different TYPE's but at the same time I need to capture rework hours, I put both information in a single line.

With this raw data, I have separated Total amount into Wastage, Quaratnine and Rework as below.

Total Sum of Quarantine = calculate(sum(Testing[sum]), Testing[Type] = "Quarantine")

Total Sum of Rework = calculate(sum(Testing[Rework Cost]) )

Total Sum of Wastage = calculate(sum(Testing[sum]), Testing[Type] = "Wastage")

With above, I plotted graphs as below

When I clicked a pie graph, bar graphs are not responded.

Is there anyway to re-establish Type with condition where Rework cost" is Not zero, its cost belongs to Rework type.

Re: any way to change Type depending on condition

amitchandak — Wed, 27 Jul 2022 15:04:04 GMT

Anonymous , Because the pie is using only measures. Only dimension values(common - Non summarized), can filter the visuals (interact)

Re: any way to change Type depending on condition

Anonymous — Wed, 27 Jul 2022 21:23:22 GMT

amitchandak is there any way to do so? Or should i do something in power query, making a new row under condition where rework house is not blank, create a new row with Type set to Rework?

Re: any way to change Type depending on condition

v-easonf-msft — Mon, 01 Aug 2022 07:28:56 GMT

Hi, Anonymous

Have you tried to apply ’Testing[Date].[Month]‘ to the ’Details‘ field of pie chart?

You can also try the following steps to modify your original model in power query.

1.duplicate a table ’testing2‘ ->remove column'Type',column 'Sum'

2. Unpivot the "Rework Cost" column,then rename the new column "Attribute" to "Type" and the new column "Value" to "Sum"

3. Duplicate a new table 'testing3' ->remove column 'Rework Cost'

4. Apend table ’testing3‘ with table 'testing2' to create a new table 'Append1'

5.In the new model, apply the field 'Type' to the 'legend, you don't need to create additional measures.

Best Regards,
Community Support Team _ Eason\

Re: any way to change Type depending on condition

Anonymous — Mon, 01 Aug 2022 12:34:14 GMT

Thank you v-easonf-msft