Forum Discussion
Toggle values of the table
- Anonymous2 years ago
Thanks for the reply from ray_aramburo , please allow me to provide another insight:
Hi,ray_aramburoRegarding the issue you raised, my solution is as follows:
1.First I have created the following table and the column names and data are the data you have given:
2. Below are the measure I've created for your needs:
Measure = VAR SELCET=SELECTEDVALUE(CHOICE[Column1]) RETURN IF(SELCET=0,IF(CALCULATE(SUM('Table'[Column3]),FILTER(ALLSELECTED('Table'),'Table'[Column1]=MAX('Table'[Column1])))=0,1,0),1)3.Add mesure to the filtered view:
4.Here's my final result, which I hope meets your requirements.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi ray_aramburo, Thank you for the response. But we do have slicers like Year and Month affecting the table, In that case, would it be difficult to take this route of creating Bookmarks? Could you please suggest us a dynamic path for the same.
- ray_aramburo2 years ago
Super User
Year and Month slicers are being used as a visual or as part of the Filters pane?